Just curious... Max size for INT is over 2 billion... that should handle your 10 million rows quite nicely for 214 tables. Why would you need unique numbers for...

Steve,

The link to "IT Project Failure" is broken.

On the subject of IT Project Failure... how often is it that IT is the one that "designs" a project? Normally, it's...

You bet...

Good tip! Thanks!

Beat me to it, Gus...

Heh... I've gotta agree there... 2 billion is usually more than enough, never mind 4 billion... what is it that you're storing?

Peso (6/9/2008)

---

I just clicked OP's "all post" to see if I didn't invent the wheel again.

If I hadn't, both you and me would present a working solution. What a waste...

Thanks for the feedback, Peter... Op seems happy with...

Nicely done, Peter! I'm still kinda new to the 2005 world and I keep forgetting about stuff like that...

heh... especially on a 2k forum 😉

Heh... yeah... 648 of them were me trying to figure out your problem... 😉

I could make it 651 ya know... 😀

I would think that a Linked Server would be able to do that... Search for it in Books Online for the details. They're pretty easy to make.

The default declaration for NUMERIC (also known as DECIMAL) is 18,0 and takes 9 bytes to store. The max precision for NUMERIC at 9 bytes is 19,0 so if...

Nicely done, Gus... Can't wait for the others!

Who does the pivoted data start out? In a spreadsheet or in a table?

If it's in a spreadsheet and you can't unpivot it there for some reason, then I'd...

Yes... it's so the system doesn't have to wait until your insert is done before anyone else can do an insert. If your insert fails (or you change your...