Here's my version to do only a single pass of the table.

But I'm not sure why you want to list only "D" in the result, since both "B" and "D"...

Seems to me like it must be two different RAID5 sets ... wouldn't different drives on the same RAID set already be using both drives?!

Either way, I'd delay your #1...

Neither CAST nor CASE is actually necessary here:

SIGN(CHARINDEX('@', <string_value>))

Btw, if weekdayid is unique (and it seems like it has to be for this table to make sense), get rid of the dopey IDENTITY column in this table! ...

Actually, it will count uncommitted records if and only if (nolock) or the equivalent is...

I prefer CROSS APPLY(s) to CTE(s) for aliasing. For example:

Select TOP 5 ID ,MID, RName,Pic1,FoodType.Descr AS FoodType,Average_P_PP,lat,lng,

ca1.Distance

From Member WITH(NOLOCK)

INNER JOIN FoodType WITH(NOLOCK) ON...

Why mess with the DATEFIRST setting when it's not necessary? There are methods which can do the calculation simply without needing a specific datefirst setting, so why hassle with...

As another kludge, you could probably do this:

COALESCE(

CASE WHEN @MonthUnits = 1 THEN GBAN01 ELSE NULL END,

CASE WHEN @MonthUnits = 2 THEN GBAN02 ELSE...

You can use a FULL OUTER JOIN to find columns that are in only one object and not the other.

I can post sample code for that if you'd like.

You're on the right track; definitely use the sys. views rather than the INFORMATION_SCHEMA views, which are not reliable in SQL Server (from 2005 on).

These are the basic tables you'll...

I've been a manager. I'm not sure immediately running to a higher-level authority reflects well on you.

Avoid the drama if at all possible. Speak privately and directly with...

Or this:

SELECT SUBSTRING(@MyValue, CHARINDEX('<EntryID>', @MyValue) + 9, CHARINDEX('</EntryID>', @MyValue) - CHARINDEX('<EntryID>', @MyValue) - 9)

UPDATE dbo.tablename

SET col = LEFT(col, CHARINDEX('.', col) + 2)

WHERE col LIKE '%.___%'

INSERT INTO #tmpJDEnbrunits

SELECT

'000' + ltrim(MCMCU),

CASE @MonthUnits WHEN 1 THEN GBAN01 WHEN 2 THEN GBAN02 WHEN 3 THEN GBAN03 --...

...

I think this rewrites the UPDATE; don't have time now to do the INSERT. The code is somewhat confusing in that sometimes ITEMID is matched on and other times...