Thanks for the feedback. People on this forum are noticeably more friendly than Oracle forums!:-D

Thank-you very much for the explanations. I'll have a look at that paper, sounds pretty useful!

@ ChrisM@home: Thanks for your solution. I'm not that advanced and was wondering if you could please explain the CROSS APPLY in your code and the benefits?

@ VIG: Your solution...

I think I arrived at a solution:

Select Case WHEN convert(varchar(20),GETDATE(),108) BETWEEN '19:00:00' and '23:59:59'

and DATENAME(dw,GETDATE()) IN ('Friday')

OR convert(varchar(20),GETDATE(),108) BETWEEN '00:00:00' and '19:00:00'

and DATENAME(dw,GETDATE()) IN ('Sunday')

OR DATENAME(dw,GETDATE()) IN ('Saturday')...

I've done some initial tests on the Top 50 and selected a few columns and grouped by these....Your code seems to work perfectly!!! Thank-you so much, it's actually amazing how...

I'm testing your code and I've run into a few errors with the group by: Error is Incorrect syntax near '*'. and when I double click on it, "GROUP BY...

Yes it maintains the convention that you mentioned 🙂

Hi this is more accurate sample data.

DROP TABLE #ClaQuestionView

CREATE TABLE #ClaQuestionView (ClaCaseID INT,Question varchar(max), Answer varchar(max),QuestionID INT,QuestionClassID INT,ClaQuestionHistoryID int )

INSERT INTO #ClaQuestionView VALUES (1234,'Did did the incident occur at...

Thank you very much for your explanations and for providing both solutions. Your query in fact does something that I hadn't initially required but is very useful and I'll be...

Thank you very much for your prompt response. I do however have a few questions. Is there a way to maintain all the columns in #InitialTable_18? There are over 40...

Hi Thanks for the feedback. I have created some sample data. I hope it is acceptable. If not please inform me, thanks.

DROP TABLE #ITCChecks

CREATE TABLE #ITCChecks (ITCScoreDate date, NameID...

Thanks for the help, I changed Datetime to date and managed to get the result that I needed.

Perfect! Thank-you for your prompt response 🙂

Hi sorry I should have been more explicit. I actually forgot to add ) to the ISNULL conditon. I now have a new issue. The query begins to run and...

Brilliant!!! Great idea, thanks for the suggestion 🙂