DECLARE product_cursor CURSOR FOR

SELECT F2 FROM dbo.Products ORDER BY tempID

OPEN product_cursor

--fetches to first row (which is NULL) so it should ideally not be stored in the variable @ColumnE

FETCH NEXT FROM...

I am using a DTS package. well lets say I put an order by ID (which is from 1 to n ascending) in . that still leaves me with me...

Hi Hall of Fame,

well I have to rely on the order of rows. The data is imported from

an excel file.

I have to use the cursor that goes from top to...

Hello Old Hand SSCertifiable,

yes, you are right, the

UPDATE dbo.Products SET F2 = @ColumnE WHERE CURRENT OF product_cursor

Is always setting the value of column F2 to what it already...

great stuff, it worked !

thanks a lot !

I will try it tomorrow!

Yes, you are right. Had a little error in my post.

I am working on a select case statement.

INSERT INTO CarType (ID,CarType)

SELECT ID,

'CarType' =

CASE -- for cartype

WHEN [CAR1] IS NOT NULL...

Issue solved,

I just changed the order of columsn in my INSERT statement from

INSERT INTO dbo.myTable(Code,Amount, Car)

to

INSERT INTO dbo.myTable(Code,Car, Amount)

Hi ALZDBA,

well I was just checking if some of the rows (real) contain characters. - they don't, but I still get a few:

-156.9

99.9

-7.8

1.8

-1.5

Odd right?

The source table is

CREATE TABLE [tmpmyTable](

[AR] [Nvarchar](255)...

Hi SSC Journeyman,

if one just uses GMT its fine but what I have done now to get GMT into PMT and others is the following:

UPDATE dbo.TimeZoneAndDateReference SET CurrentDate=DATEADD(hh,4.5,GetDate()) WHERE TimeZone='GMT+04:30'

UPDATE...

Hi Guys,

thanks a lot.

@GSquared, well I think you have to run it hourly to get some precision into it.

Because at 11:35pm it might be the 3rd of October...