Not really enough information to give a good answer.

Read http://www.sqlservercentral.com/articles/Best+Practices/61537/ on how better to post your question.

/T

Okay that is one horribly slow way of doing that. Now i dont have a script for doing this myself so creating one from scratch i have dropped some stuff...

Hi

Borrowing abit off code from various post in http://www.sqlservercentral.com/Forums/Topic1042310-149-2.aspx and modifying it a bit. Thanks to Jeff Moden and GSquared.

You could do something like

create function a (@actions varchar(50)) returns varchar(50)...

sc-w (1/4/2011)

---

Hi,

I have a field called contact that has peoples firstname and lastname in, the data looks like "JOHN SMITH" for exmaple. What i need to do is to alter...

There fixed it...

CELKO (12/22/2010)

---

>> I have a SQL Server database that holds patient information for the cancer department that I work in. I have a Patients table and Appointments table. <<

Please post...

Or the OUTER APPLY version

declare @Patient table

(

Pat_ID integer not null primary key,

LastName varchar(100),

FirstName varchar(100)

)

declare @Appointment table

(

Appt_ID integer identity...

GSquared (12/17/2010)

---

vinothraj (12/17/2010)

---

I'm working in linked server but you might be working in your own. i just told it based upon the average of ten times but i would like...

I seriously doubt that it takes 0.21 SECONDS to run current_timestamp (or getdate() for that matter) one...

Jeff Moden (12/16/2010)

---

@tommyh

Thanks for the feedback. You are, of course right about "It Depends". Guess I'll have to yank out some examples of what I ran into on...

Jeff Moden (12/15/2010)

---

IMHO... [font="Arial Black"]ABSOLUTELY NOT!!! [/font]:-P

While it certainly is easy to write an rCTE to do this, an rCTE will use a...

Could have done what i did... ran the code. Now i knew that...

Good question but the answers are a bit... unfair.

The 2 answers:

Throw an error: Invalid object name '#tmp'.

Throw an error: Cannot find table #tmp inside TempDB.

Have the same effect (no...

ronmoses (12/8/2010)

---

Exactly. I knew I was answering the question incorrectly -- it was the result...

Those points also go up from posting....