It doesn't matter that multiple users will access the proc at the same time. Temp tables are connection-specific.

So long as your tempdb database has enough room in it (or...

That's what I do.

UDBNT (5/8/2008)

---

Bowing to those individuals with better SQL knowledge than me, but surely the supplied statements from zahran is a bit like running down the road to the sweet shop...

If it needs to be unique, why does it need to be random?

Would a sequential (identity) number accomplish what you need?

If it truly needs to be both random and unique,...

Jeff Moden (5/7/2008)

---

GSquared (5/7/2008)

---

I ran some speed and load tests on this code.

Summary: While the CTE works, and is fast by any normal standard, the Numbers version is even faster,...

If I'm not mistaken, the specifications for the encryption protocol will give you that information.

Mahesh Bote (5/5/2008)

---

[font="Verdana"]

Are you handling errors at front end with Try Catch block?...

SQL doesn't let you use variables that way.

What I would do is (a) figure out if a cursor is really needed for this or if it can be replaced with...

That works.

Personally,...

Actually, when I see one totally assinine thing in the server, I assume there's...

In that case, indexes are a waste of time. Don't bother with them.

Indexes are mainly useful for data that...

Since you're using "convert decimal(3,2)", you're getting an overflow error if the number is higher than 9 in any case. In decimal, the numbers in the parentheses determine how...

I read that ghost cleanup is part of the autoshrink process. Do you have autoshrink turned on for this database? If so, turning that off should help your...

I'd do the whole thing as a calculated column, instead of updating it.

alter table Table1

add column AuthDate as (

case

when ADate > BDate and ADate > CDate then dateadd(day,...

Create the temp table first, then insert into it, instead of creating it as part of the select statement.