Not dynamic, but if you know the values that will appear in item then:

select a.name,
       sum(case when b.item = 'red' then...

This bit looks odd and long-winded:

AND EXISTS (
SELECT 1
FROM (
SELECT PARTY_ID
FROM C_B_ACCOUNT WITH (NOLOCK)
GROUP BY PARTY_ID
HAVING count(1) = 1
) A
WHERE A.PARTY_ID = ACCT.PARTY_ID
)

I would write it like...

It could be that someone is creating large tables for temporary storage in tempdb. I don't see anything wrong with this if they have done it to improve the performance...

I see your description and your code but I still can't figure out what you're trying to do.  Are you simply trying to show what the Thursday week start...

You have written a script that if you run it twice you will get a different answer:

SET DATEFIRST 1
DECLARE @dayOfWeek int, 
     ...

If you go into menu item Tools/Options, you can change the value from 200 to a different number:

Or if you click the "SQL" button once you have...

• This reply was modified 6 years, 10 months ago by Jonathan AC Roberts.

You haven't shown the query you have written or the results you are getting.

SELECT t1.ID, t1.Name, t2.ValueA, t3.ValueB
  FROM Table1 t1
 INNER JOIN Table2 t2 
...

I think you can do the update with a single query, something like this:

;WITH CTE AS
(
    SELECT DISTINCT cdi_type,
     ...

Like Source control in TFS or GitHub

Why the extra step of replacing the concatenated CR and LF?  Doesn't replacing the individual CHARs suffice?  That's how I've done it, and I'd like to know if there...

The statement and what SQL Server does with it are two different things. SQL Server converts the CHOOSE to a bunch of CASEs and RAND() ends up being evaluated...

But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
   ...

But this one doesn't return NULL, so a bit puzzling to me

SELECT CHOOSE((CAST(T.[Rand]* 10 AS INT))%3.00 + 1, 'one', 'two', 'three') Choice,
     ...

From the Microsoft BOL:

Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition....

Two single quotes together ('') is evaluated to be the same in an inequality expression as a space character [char(32)].

Couldn't you just use char(9) for your comparison instead of the...