Thanks 🙂

There is no need to remove the policy #

It

Hi,

Use CASE expression within SELECT statement to get your desired result.

cheers

Thanks Jeff. Really appreciate your help mate.

Thanks Jeff.

How can I avoid a cross join for the following query?

SELECT a.Week, a.StartDate,

CASE WHEN purchasedate BETWEEN a.startdate AND a.nextdate THEN 'Yes' ELSE 'No' END...

Thanks Hitendar n Jeff for your inputs.

I have modified my query to my needs:

SET DATEFIRST 1 --Monday to Sunday week

DECLARE @FirstDate DATETIME

/* For any year start add Jan 1 +...

Jeff, I have a problem.

The query is working fine and listing all week numbers and dates.

However, I am interested in week day starting Mondays which is 05/01 for current year...

hi hitendar

any comments?

cheers

thanks jeff.

I would display 0's to indicate there was no data during that particular week.

--Ta

hi mate

thanks for ur response; appreciate it.

sorry if i wasnt clear, i need week numbers and week start dates for any given date range or a year. if it was...