Viewing 15 posts - 3,646 through 3,660 (of 18,926 total)
Jeff Moden (8/7/2011)
August 7, 2011 at 8:31 pm
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...
August 7, 2011 at 8:15 pm
Jeff Moden (8/7/2011)
Ninja's_RGR'us (8/7/2011)
@jeff:Whistling::arrow:
Ninja's_RGR'us (8/5/2011)
Might I point out that using the right nickname is a good start with the basics.
kraigCraig :Whistling:
So you don't think it was important enough...
August 7, 2011 at 8:12 pm
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.
August 7, 2011 at 8:06 pm
WayneS (8/7/2011)
Ninja's_RGR'us (8/7/2011)
Come back anytime you want, you'll always be home here with us!
Lynn, I completely agree with this.
... but I just have to say... "Resist the dark side of...
August 7, 2011 at 7:55 pm
vision59 (8/7/2011)
It is user definition with Uniqueid(numeric(16,0) and passing as output still seeing this error.
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)...
August 7, 2011 at 7:53 pm
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...
August 7, 2011 at 7:23 pm
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...
August 7, 2011 at 7:22 pm
Lynn > sp_update_resume, sp_deploy_resume :-D.
Come back anytime you want, you'll always be home here with us!
August 7, 2011 at 7:16 pm
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...
August 7, 2011 at 7:15 pm
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...
August 7, 2011 at 7:09 pm
:Whistling::arrow:
Ninja's_RGR'us (8/5/2011)
Might I point out that using the right nickname is a good start with the basics.
kraigCraig :Whistling:
August 7, 2011 at 7:07 pm
7 straights posts Jeff.
The man's on fire :-D.
August 7, 2011 at 7:03 pm
August 7, 2011 at 7:00 pm
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/
August 7, 2011 at 6:59 pm
Viewing 15 posts - 3,646 through 3,660 (of 18,926 total)