Magnitude of what ??

Sorry..dont understand...

From what I saw in your pictures, the files may not be zipped. Hard to tell. I think it is relevant only if you expect the download process to unzip...

Lynn,

I have seen your work, and I know its first class. But I am sorry I can make you rich, but I would be pleased if you are keen....

Thanks..

Number of rows is variable.

Zipped, as far as I can tell. NOT Zipped !:-)

This 2005 function "GETUTCTIME"

This works off server time, to give current GMT.

So when server time is adjusted for day light saving I will still get GMT from this GETUTCTIME???

Just checking...

Thanks kind folks should be able to get over this hump now !

Lynn..you have helped me before..thx:-)

SELECT TOP 1 Data1, Data2, Data3

FROM myTable

GROUP BY Data1, Data2, Data3

ORDER BY Data2

this code looks goog to me:

http://www.aspheute.com/english/20040105.asp

Yes thats is correct, all is an table. So the consensus is that my SQL is correct and...

Yes thats is correct, all is an table. So the consensus is that my SQL is correct and...

Yes thats is correct, all is an table. So the consensus is that my SQL is correct and...

Yes thats is correct, all is an table. So the consensus is that my SQL is correct and...

Every one is a comedian.

Life of Brain ! ( I am kidding )..

Thanks all sorted now !

This code is for an ASP.net project, data input comes from 3 textboxes that will out put a string each.

Thanks the out put was

1A10

2B20

3C30

Where did the column 'ItemID' come from, have you made changes to the 'DelimitedSplit' function, by allowing and 'Identitiy field ' (increment at 1) .

If...