What is it that the 2 users are doing that's tying up a SQL server that way?

Unless they're accessing a LOT of data, sounds like something's very wrong....

Just about the only way to "resequence" an identity table like what you wish is to drop the identity column, and add a new identity column. And voila -...

Let's try another "hint" to see if that works too. You want to grab the SUBSTRING of the combined name starting one character after that very same comma, and...

What are you using this for? If you're just using it for some kind of display purposes - skip messing with the actual column, and use a calculated ROW_NUMBER().

Select...

What's available today is SQL Server 2008 CTP 5 or 6. Meaning a "full-featured" community Beta version, but no - not the retail copy. That's delayed (as of...

Then CHARINDEX is your friend. You will need to plit off the last name into its own field FIRST, and then worry about the possibilities of a second comma...

Your issue is in bold

yanine (2/27/2008)

---

declare @representative varchar(255)

set @representative= 'Victaulic'

exec ('

select me.Member_Id, UPPER(me.Member_Name)as Member_Name, me.Member_City, me.Member_State, me.Member_Fax

from members me, Manufacturers m, Manufacturers_Categories mc, Categories c, Representations r

where me.Member_Id...

I'm not sure how you'd do that from one single stored proc. As far as I know you'd need three separate sources, each yield one resultset, and three separate...

He's right on one point and wrong on yet another.

There is definitely some truth to the fact that there is some very minor amount of work required to pull the...

Jim Russell (2/27/2008)

---

Matt - I'm embarrassed that I didn't realize that at the time; being in a hurry I just cursed and set the field back to an int. Guess...

The property doesn't change, but the behavior does. Meaning - even if the delete said CASCADE, that's behavior within the constraint, so it doesn't fire (since you've set it...

Patrick (2/25/2008)

---

I was wondering the same thing. I tried the suggestion and it worked. Great, thanks.

But WHY? Why does including 'if not exists' cause it to use sp_executesql? Is that...

Kurraghu - it's stored in increments of a day. so it's .5023 of a day.

So 1day = 24 hour=24*60 minutes = 24*60*60 secs,

therefore .5023*24*60*60=43398.72 sec = 723 minutes 18.72 secs...

Oh no - I'm no longer "allowed" to play MMORPG's.....:D. I have to steer clear of those if i plan on ever getting any sleep. Funny thing -...

Sugesh Kumar (2/27/2008)

---

I have seen people reporting this few many times. With SQL server 2005, Browser services needs to be started in machines that have more than a instance. ITs...