Are the records in the tables in question ever updated or just inserted?

+1

Just because you can do something doesn't mean you should. Doing this sort...

Is someone a loyalty customer because they have an entry with PurchaseDetails of 'Loyalty Customers' on a particular day, or is that designation inherent to the customer himself/herself?

I think you...

I believe that any generated scripts will not prompt for a save. Anything you modify at all should prompt you.

Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev team at MS that...

The first solution I posted above (the first reply to Phil) is a clean "islands" style approach that I don't believe is improved upon by the other similar approaches. ...

Thank you my friend.

Yeah, Mark's is much better. I went to lunch and realized that the much cleaner query had eluded me.

Do a web search on "sp_msforeachdb".

This solution uses a numbers table in [master].

selectdt.HotelId

,dt.RoomTypeId

,BeginRange = dateadd(dd, min(dt.N), '20000101')

,EndRange = dateadd(dd, max(dt.N), '20000101')

from

(

selectdistinct

rd.HotelId

,rd.RoomTypeId

,n.N

,grp = n.N - dense_rank() over(order by rd.HotelId, rd.RoomTypeId, n.N)

from #RoomDates as rd

join [master].dbo.Nums as...

I don't think that the argument should be that string evaluation and manipulation cannot be done in t-sql, it's that they cannot be done nearly as efficiently as they can...

I may be misunderstanding what you're asking, but in the 2nd article you link he gives a nice example of what will be returned by $action in different situations in...

I believe it would be possible but it really wouldn't make sense. There is an overhead to parallelism: the work has to be divided between CPU's and then the...

Jeff, I'm a bit confused. Are you saying that parameter sniffing is more likely with dynamic sql? I don't understand that to be the case (and I would...

I appreciate that you're new to SQL Server and please don't take what I have to say as anything other than me trying to help you learn some things. ...