Jeff Moden (8/7/2011)

---

Gosh... sorry Remi. If I've told you to read the full thread in the past, I'm sure sorry about that. It's not always possible to have...

I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our collective understanding...

Jeff Moden (8/7/2011)

---

So you don't think it was important enough...

I'm off to bed now. But if you could send a screen shot of what you did / and see it would be very helpful to solve this.

TIA.

WayneS (8/7/2011)

---

Lynn, I completely agree with this.

... but I just have to say... "Resist the dark side of...

That's well over the limit of an int and even a bigint..

http://sqlserverplanet.com/sql/sql-server-bigint-max-value/

Declare your variable as numeric(16,0)...

I've seen the same issue over an dover when importing in access or excel.

Are you sure you selected the fixed width option instead of delemited (God only knows how many...

My first bet like Jeff would be a bigint identity.

Then the variable being declared as int or smallint if it's an int identity.

I don't really think it can be...

Lynn > sp_update_resume, sp_deploy_resume :-D.

Come back anytime you want, you'll always be home here with us!

Only 2 things can be happening here. Either you're doing a pivot (and missing the max() function)

or you could perharps just move this in the where clause (on the...

Do you have jobs running (in sql agent)?

Do you have 3rd party app like backup exec?

Maybe posting the full error message (excluding server name and logins) would help us pinpoint...

@jeff

:Whistling::arrow:

7 straights posts Jeff.

The man's on fire :-D.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

I think this is an excellent read for you... next time you got 15 minutes to invest in yourself.

http://www.simple-talk.com/sql/t-sql-programming/rbar--row-by-agonizing-row/