Apart from ssis control , It's a theory and can be implemented out of SSIS .

how do you want to store it ?

check out nodes method at msdn .

http://msdn.microsoft.com/en-us/library/ms188282.aspx

use MAXRECURSION hint.

check this out:

thanks for the question;learned about xml indexes .

Create an SP that takes the validation error input and prints the message;

that would make it cleaner.

cast ((Result+1) as numeric)

If you use Int ,in this case BigInt , then you won't be seeing this error...

haiao2000 (8/5/2012)

---

Demonfox,

I don't anticipate we keep every version of the data as it is very expensive to do so, but it is likely that user wants to have several versions...

declare @mysql varchar (1000)='create table #team1(a int); select * from #team1'

exec (@mysql)

I am not sure what you are looking for, but for # you don't need to do anything...

case when @StartDate<@EndDate then

DATEDIFF(dd,@StartDate,@EndDate) + 1

when @StartDate>@EndDate then DATEDIFF(dd,@StartDate,@EndDate) - 1 end

if it's just one version , you can have the back end loader to dump the data in the new table and have front end configured to use new table...

you can create an archive table that keeps only the previous version data, it's good to have the history information in other table. Also it depends how your business requirement...

I don't think counting a null would be an issue , It depends how are...

I don't have 2012 yet , I went through msdn

http://msdn.microsoft.com/en-us/library/ff878091.aspx

I thought the answer would be min(bigint)+1 ; and that wasn't listed ; didn't understand the defaults ..

guess need to...

great question, although I got it right, but I am glad i read the posts .Otherwise , I may have ended with wrong idea.

what company is that !! 😛

a better way to start-...