Have you tried to use DATEPART(wk, Date)?

What have you tried?

Here's a simple solution you could use

select a.*,

CASE WHEN a.RankID = MIN(a.RankID) OVER( PARTITION BY a.PatID)

THEN b.ModelID /*ELSE 0*/ END ModelID

from TableA1 A

inner join TableB1 B...

How about this?

SELECT TOP 1 *

FROM MyTable

ORDER BY DateOfBirth DESC

As far as I know, those dependencies are only within the database. If there are objects...

Without a lot of information, I guess you could do something like this.

SELECT distinct BO.NMDOS,

CASE WHEN FT.FNO = MIN(FT.FNO) OVER(PARTITION BY BO.NMDOS) THEN bo.ETOTALDEB END...

I'm not sure you should do this as it might give you incorrect results if there are several people with same name and DOB (chances are low, but it could...

Actually, there seems to be a problem with the median formula.

This should perform better and give the correct results. It's up to you to change it to your needs.

DECLARE @test-2TABLE(

myintint)

INSERT...

Something like this?

select *

from sample

WHERE a <> b

OR a <> c

OR a <> d

OR b <> c

OR b <> d

OR c <> d

To avoid the zero and have nulls, you just need to eliminate the else.

Maybe this index will help

CREATE NONCLUSTERED INDEX [IndexName] ON [dbo].[TableNAme]

(

[Id] ASC,

[TradeDate] ASC

)

INCLUDE ( [Value]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF)

But...

I'm glad I could help.

Remember to try the pre-aggregation option to improve performance even more and you could check the second part of Cross tabs for further learning. You...

There's a need for a NULL validation since the OP wants to show NULLs as well.

I don't get it. Could you please post sample data and expected results? Check the article linked on my signature to guide you.

Your description and the results seem to match,...

You're welcome. I'm glad I could help 🙂

I believe this option is better for performance.

SELECT ID,

SUM( CASE WHEN Type = 'a' THEN Amount ELSE 0 END) AS Amount_A,

...