@gilamonster

Its just a requirement, i hope by doing this i will not break any law :unsure:

@abhijit-2 More

I am not an advance user, just a programmer so would you please describe 🙂

thanks all for your replies,i know all the above rules and constraint about the relational database, my intention was to know the reason behind this rules. BTW thanks once again.:-)

Thanks Steve! 🙂

ummm... i guess admins are too much busy, that they cant even reply.:-P

whats this all about? :blink:

Thanks very much Jeff!:-)

Thanks for the wonderful code Jeff. Please keep posting this kind of code which will help others to write complex queries in simplest way.:-)

yes jeff , you are right...following code will work on n Number of records. have a look!

SELECT TOP 10000000 --<<! Change this number for testing different size tables

RowNum = IDENTITY(BIGINT,1,1),...

Jeff,

I was trying to find out the maximum number of records it can work with and its working fine with 6791500 records in my SQL Sever's Server having 8 GB...

Hi, Gud morning

i have used the same code for testing with 10 million records, as code itself is inserting records, so i have nothing to do with the data.

the method...

Great piece of code Jeff but i have tested it with 10000000 records and i am getting Arithmetic overflow error converting data type' :unsure:

I am working a Developer in an...