Hello everyone!

I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the...

Hello everyone!

I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the company...

SELECT CONVERT (decimal(9, 2) , CAST('$15,000.50' AS money))

No need to specify the last day / number of days in the month, that can easily be calculated:

(CASE WHEN MONTH = @month AND DAY = @day...

I agree.  In fact, any book on T-SQL by Ben-Gan will be worth studying.

You might find it easier to reason about with EXCEPT and INTERCECT.

SELECT DISTINCT KEY FROM myTable WHERE type = 'COLL' and subtype = 'MOD'

EXCEPT

SELECT DISTINCT KEY...

Yes.  If you only want a key that has both conditions, change the MAX:

MAX(CASE WHEN type = 'QUAT' AND subtype = 'BALANCE' THEN 1 ELSE 0 END) = 1

Note that...

SELECT key
FROM dbo.your_table_name_here
GROUP BY key
HAVING MAX(CASE WHEN type = 'COLL' AND subtype = 'MOD' THEN 1 ELSE 0 END) = 1 AND
    MAX(CASE WHEN...

I don't think so.  PIVOT works on only one column at a time, IIRC.  A cross-tab is almost certainly the best method here.

Great point; sorry, I accidentally left out that "current year" requirement.

If you just want the MemberID, then as below.  Of course you can adjust the query against the cte to pull more columns if you want them.  Either way, I...

Can you clarify...

You want the unique clustered index on ( date_, ID_vard ), assuming that you do primarily query the table by date_, and not on just ID_vard.

You likely should encode the room name for internal use -- I'd probably call it "room_code" -- but you'll need at least a smallint, and I'd probably just "byte" the...

I am going to add this statement at the top of the SP, it will prevent or minimize deadlocks:

SET DEADLOCK_PRIORITY HIGH

No, it won't.  Instead, it will force SQL to kill...