Try Change data capture http://msdn.microsoft.com/en-us/library/cc627397.aspx

What im getting at is that IF you are adding a column , for example, for January2010 data and then for each subsequent month you need to add another column...

Please tell me this is a one off , oh i need to add a new column sort of a thing , and not a programmatical add a new...

Jack Corbett (2/3/2010)

That's definitely true. My take on many posters at least since I got back from the Summit is that I'm getting fewer responses when I ask questions...

When i started in this business it was a science , i still try to see it like that.

Unfortunately that does not seem to be the case for some...

Could be down to something like different ANSI settings. Is there something silly with different date formats occuring, If you are positive that if you pass the EXACT...

This should all be fairly easily achieved by use of the row_number() function.

Once happy that you are able to target the right data , ie all the rows you wish...

This is because when using adhoc...

What results do you get from

Select * from ProductSubGroup where ProductSubGroup.id =13

The Dixie Flatline (2/2/2010)

---

Curiousity question. Have you seen any documentation about the performance of scalar functions which do NOT do data access compared to inline table valued...

Just guessing , but 11001310 could be the number of minutes from '01jan1970', though what 25520000 would mean is anyones guess.

If its stored in oracle like that , you need...

select top(10) number from master..spt_values where type ='P'

go

select top(10) number from master..spt_values where type ='P' order by number

go

/* BOTTOM X Rows */

select top(10) number from master..spt_values where type ='P'...

Why ? The Bottom X rows are the first X rows ordered descending.

Can you post the DDL ?

When you repost the data , is it EXACTLY the same data in EXACTLY the same order ?

How many times do we have to go through this one ???

http://www.sqlservercentral.com/Forums/FindPost857143.aspx