SQL NULLS

Hi, I have a large table from which I want to convert certain columns from varchar to int while loading the table to another table. However, I run into problems when the input column contains empty cells. The SSIS data conversion data flow item can't handle these so I tried the script component. With the script component I can convert these empty cells to zeros but after that I'd need to use SQL update to update the zeros to nulls which in the case of a large table with over 3 million rows takes unnecessarily long. So, is there another way?

How do I deal with null values in this section it throws errors when they leave the field blank it is a small order form and they don't have too add data to all the fields .   comm.Parameters.Add("@item_9223", System.Data.SqlDbType.Int);                comm.Parameters["@item_9223"].Value = Int32.Parse(txtitem_9223.Text);                comm.Parameters.Add("@item_9129", System.Data.SqlDbType.Int);                comm.Parameters["@item_9129"].Value = Int32.Parse(txtitem_9129.Text);                comm.Parameters.Add("@item_42795", System.Data.SqlDbType.Int);                comm.Parameters["@item_42795"].Value = Int32.Parse(txtitem_42795.Text);                comm.Parameters.Add("@item_30695", System.Data.SqlDbType.Int);                comm.Parameters["@item_30695"].Value = Int3

I created a Package in the Business Intelligence studio to Import data from Excel file  into SQL Server 2005 using a Excel Source and a OLE DB Destination that uses a data convertion transformation before it reaches the destination a mjority of the data is copied over. However i am having 2 Issues. 1. In the Date field some of the values appear as Null in SQL Server 2. I need to change the format of the date in Excel from dd/mm/yyyy to mm/dd/yyyy before inserting into SQL Server if Possible. I am not sure of the solution for Ques 1 but i attempted using a script task for #2 It did not work. Please Advice what the best way to proceed Thanks.

hi thankz in advance,i have 2 tables t1 and t2in t1 i have 4 columns from that i want to insert only 2 columns to another table t2 i only want to send data which is in the form of ip adress like(123.123.123.123)after eliminating nulls and other data.plz suggest me is it possible to write a query or i need to do it programetically.thankz a lot..

Hi,I have 6 tables I want to join and and need to handle a null value when doing an aggregation of certain values.Table 1: Staff - Col: StaffID StaffNameTable 2: SystemUsers: Col: StaffID DepartmentIDTable 3: Bookings Col: BookingID BookedByID(fk for StaffID)Table 4: Transfers Col: TransferID BookingID(fk) BookedBYID(fk StaffID but can be null) 'I didnt set up the tableTable 5: BookingPayments COl: PaymentID BookingID(fk) CommissionTable 6:TransferPayments Col: PaymentID TransferID(fk) CommissionBasically I have to sum  up the commission for each of the staff members that made the booking or transfer.I need the StaffID, Staff Name , sum(commission) and Departmentid. Now here lies the issue all transfers are linked to a booking and the payments are linked to either a transfer or a booking.If it is a transfer booking payment I need to add the commission to the staff member(bookedbyID) in the Transfers table but if this value is null then I have to use the Bookings BookedBYID value, I would also need this to flow onto getting the Staff Name from the Staff Table and the DepartmentID from the SystemUsers table.I have got a query but it misses out the Null valued rows for the Transfers and their payments.Would like some fresh ideas so I will not post my shocking query.Thanks P

hi i have tbl_ip i want to filter nulls and duplicate to my tbl_ipfilter can u suggest me a stored procedure for this. data of tbl_ip is like below . ip 27.24.83.105 NULL NULL NULL 92.20.83.203 92.20.83.203 67.21.83.315

HI All,

 

Is there a way to use non empty in excel(which is connected to cube) like the way we use when writing MDX? We have a couple of values that have empty metrics and we wan to filter them out.

 

Thanks in advance.

I am retrieving a database object and trying to set the values of the object's fields to various textboxes in my vb.net page.

 

However, since some of the database fields have null values, I am getting the following error.

System.InvalidOperationException: Nullable object must have a value.

 How do I solve this problem? 

Caller to Draw.cshtml

        if (errors == false)
        {
            PageData["Range"] = zoom;
            PageData["StartReal"] = startRe;
            PageData["StartImaginary"] = startIm;
            PageData["StartColor"] = startColor;
            PageData["N"] = N;
            PageData["SizePic"] = sizePic;
            @:<img src="@Href("Draw.cshtml")" />;
        }
Here all variables have a value,

however when arriving in Draw.cshtml the PageData all pass as null.

Draw.cshtml

@{
    var zoom = PageData["Range"];
    var startRe = PageData["StartReal"];
    var startIm = PageData["StartImaginary"];
    var startColor

Help!

I have a SQL Server column FileLocation which is declared
varchar(150), not null

Some of the values look like nulls to me ..
len(FileLocation) gives zero length

But..
Isnull(ltrim(rtrim(FileLocation)), 'test')

..does not bring back 'test' - why is this?

Do I need a patch for my sql server version? a service pack?

TIA

Hello all,

I have a program which has 11 variables. 5 of these can be empty strings which I need to be inserted as NULLS. I have tried to figure out where I am failing in my code without success. I hope someone here might be able to see what I am doing wrong. Many thanks and here is the code:

 private void PostDatatoServer()
        {
            String connectionString = @"Data Source=LUCKYTIGER\SQLEXPRESS;Initial Catalog=John;Integrated Security=True";
            SqlConnection con = new SqlConnection(connectionString);
            con.Open();
            textBox1.Text = "Connection made";
            string str = "";
            str += "INSERT INTO Parsed(Date, Gal, Sys, Sl, ST, PN, PlayN, Sym, Rk, All, Rel)";
            str += "VALUES(@Date, @Gal, @Sys, @Sl, @ST, @PN, @PlayN, @Sym, @Rk, @All, @Rel)";
            SqlCommand cmd = new SqlCommand(str, con);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add(new SqlParameter("@Date", uegParser.strTime));
            cmd.Parameters.Add(new SqlParameter("@Gal", Convert.ToInt16(uegParser.strGalaxyNum)));
            cmd.Parameters.Add(new SqlParameter("@Sys", Convert.ToInt16(uegParser.strSystemNum)));
            cmd.Parameters.Add(new SqlParameter("@Sl", uegParser.intSlot));
            cmd.Parameters.Add(new SqlParameter("@ST", uegParser.intSlotType));