Viewing 15 posts - 52,966 through 52,980 (of 59,068 total)
Step 1 should be to nomalize the table so things like this become much easier.
January 11, 2008 at 8:17 pm
The real culprit is likely going to turn out to be a deadlock. You need to read "Deadlocks, detecting and ending" in Books Online. Pay particular attention to...
January 11, 2008 at 8:03 pm
SQLElhassan (1/11/2008)
The Numbers table worked perfectly for me but I want to have my leading zero back in the PK field. Like I explained above, I'm...
January 11, 2008 at 8:00 pm
aliciakw123 (1/10/2008)
I am trying to set up permissions in SQL 2005 to give a user Read Only rights to the table, but he needs to be able to create views.
As...
January 11, 2008 at 7:55 pm
Would you please post the data in a code window so it doesn't wrap?
January 11, 2008 at 7:51 pm
You should probably check which columns are in the index vs what you update in the tables... if you're modifying those columns, that'll certainly cause the index to jump about....
January 11, 2008 at 7:47 pm
First, it's not likely that we'll actually be able to see the document on your "C:" drive.
Second, you haven't explained what you want the proc to do.
Third, if you want...
January 11, 2008 at 7:41 pm
Even in SQL Server 2000, there is no need to engage any systems tables to figure out if an object exists...
IF OBJECT_ID('someobjectname','xtype') IS NOT NULL
... object exists ...
ELSE
... object does...
January 11, 2008 at 7:36 pm
Careful... that's only guaranteed to work correctly if one of two things happen...
1. You have a rock solid clustered index on the correct columns and you have an "anchor"...
January 11, 2008 at 10:24 am
Including name in the sub-query will not guarantee unique SSN's. 😉
Still, I'd like to know... not that I'd do it with a Temp Table, but what's so important about avoiding...
January 11, 2008 at 7:31 am
By the way... there shouldn't be a header on fixed width output...
... and, contrary to what's been said, BCP makes a nice fixed width output if you use a format...
January 11, 2008 at 7:16 am
Michael is correct, as well... if you create a temp table in a nested proc, the outer proc will not be able to see it. If you create a...
January 10, 2008 at 4:46 pm
Ramesh (1/9/2008)
Thank you very much for ur response...Without temp Table is it possible?..
can u plz explain me
Why do people always ask that? What's so poison about temp...
January 10, 2008 at 7:39 am
Just in case you want to know why Matt says the performance will suck...
January 10, 2008 at 7:36 am
Viewing 15 posts - 52,966 through 52,980 (of 59,068 total)