If you are concerned about disk I/O you might want to look into using the Partition features of sql to partition filegroups to maximise I/O. - Just a thought 🙂

Strange, this works fine for me, what version of sql are you using?

Congratz buddy! Welcome to team SQL!! 🙂

Loundy (1/26/2012)

---

You won't be able to combine the results from both statements as the columns are not the same. If the columns were the same in each statement you...

You won't be able to combine the results from both statements as the columns are not the same. If the columns were the same in each statement you could...

The way you have the procedure written can logically return 2 data sets as you are checking for different conditions @patientid > -1 and @pid > -1

Does your application always...

I've managed to come up with 1 solution:

ExecuteSql('DATETIME', 'SELECT CONVERT(CHAR(11),GETDATE(),120)')

this will give the expected result. if anyone can come up with a better way to do this...

I've just...

What version of SQL you using? If 2008 you can use the TIME data type:

http://msdn.microsoft.com/en-us/library/bb677243.aspx

you shouldn't have to explicitly insert a value into an identity column. The idea of the identity column is to auto increment - so when a new value is...

hxkresl (8/8/2011)

---

I quote Dave Pinal: "One of the most important advantages of MERGE statement is that the entire data are read and processed only once. In earlier versions, three different...