I just wanted to add that we had tried using NAS in the past and we were disappointed but things have changed.  Because of the changes, we are in the...

Thanks guys.  As my post said, about half-way through, I thought this was the case but I just needed clarification.

Thanks again,

hawg

Another option would be to build a table to hold the values for your parameter values and use that table in your procedure.  This method could help you avoid a...

Sorry guys, two things.  One, the server I did this on earlier was also EE.  Extra memory cannot be used with Standard Edition.

Also, I won't be applying SP4 yet.

Thanks,

hawg

Just wanted to mention that you might want to try the Free SQL Server Add-on Tool called SQL Digger (http://sqldigger.bdsweb.be/).  This tool is great and easy to use.  You...

Thanks for the help.  I actually ended up building a UDF to handle this because we have this scenario many times in our development.  In many of the apps we...

My apologies, I may not have made my example clear.

Assume this is my procedure:

CREATE PROC usp_CheckList(

 @parm  varchar(100))

AS

SELECT *

FROM dbo.MyTable

WHERE checkfield IN (@parm)

GO

The value I am passing into the procedure is:

'ABC','XYZ','JKL'

Is there...

Thanks for the insight.  I had just never seen this before and I was curious.  Everything makes sense.

Thanks again,

hawg

You wrote:

NAS or SAN

Microsoft does not recommend the use of NAS for the performance problems you've cited. If you have the option, go with the NAS or a dedicated...

This is just taking a shot based on what you gave and without the DDL but give the following a try.  If it doesn't work, we really need to see...

Expanding on David's solution, if you wanted to, you could remove the leading zeroes but keep spaces for these zeroes using the following:

REPLICATE(' ', PATINDEX('%[^0]%', [Name]) - 1) + SUBSTRING([name],PATINDEX('%[^0]%',[Name]),LEN([Name]))

Not...

Rob's answer still works only with changing the "C" sort from desc to asc like the following:

select * from #tbl t

where t.i =

(

select top 1 t1.i FROM #tbl t1

where...

Calm down Joe before you blow a gasket. 

I've never claimed to be a complete SQL expert and this was just a quick example.  Regardless of what the definition is...

I will agree that it is best to build your database where there is a logical PK but I have had multiple instances where I simply needed a unique ID...

Rob's answer is the best with one exception, you will need to make the sort for "c" to be ascending instead of descending.

Joe, I'm curious why you said you never...