THANKS I FINALLY UNDERSTOOD!!!:)

Appreciated, Lynn!

tried your way but i still dont uds... Especially the co-relation between num and gap in order to derive Consecutive_D. Sorry to be so noob. If u dont mind, can...

I know this is an slightly old thread but i have some qns on

nigelrivett's solutions. I know there are better solutions offered, especially by Lynn, but i have already...

Careful now. I realize that Lynn has already pointed it out but I want to emphasize it... The example that Lynn gave is the correct one (the...

Oh ok thanks... i uds le;)

what does the partition does? and how does it affects the generating of row numbers. Does it have a similar function as GROUP BY?

Thanks, yup i read that must still not as clear....

[/b]

---

So if i have an sql statement in my execute sql task that looks something like this:

Delete from TABLE where (CREATION_D = ?)

CREATION_D is the column i am discussing about....

Hi i am sorry, its solved, error with my file path.. thanks for pointing that out

Its stored in numerous folder due to requirement. May i know which should package should i identify? the one inside the project folder, with...

Oh i get it already. So which one is recommended? Better performance maybe? THanks to the two pros!

thanks alot for the solutions. I shall test run it later. Appreciated, both of u.

omg i am losing the discussion over here... so the recommended solution to me is which? And is it a typo or? why there are two '??' sry for the...

So if i have an sql statement in my execute sql task that looks something like this:

Delete from TABLE where (CREATION_D = ?)

CREATION_D is the column i am discussing about....

Michael Valentine Jones (1/3/2013)

---

There is no DATE datatype in SQL Server 2005, but it is available in SQL Server 2008 and above, so if upgrading is an option, that is...