Agreed, how about a little meaning to this problem. I mean the record with a 'StartTime' label and no start time really has me worried.

Well at least with this query I can get at the row counts.

But the stuff at that link is pretty murky. I can't make heads or tails out of it and...

"Very procedural": Yes, but it beats accessing a table hands down.

"Very propietary": Don't understand that one. Or maybe are you referring to the fact that it's very SQL Server specific?...

Thought about Vladan's point 3 where a table approach would use a query like:

select count(*)

from cal

where d>=mydate1 and d<=mydate2 and h=1

But by adding another column holding a sequence number 'n'...

Posted this recently for calculating work days between two given dates. No table required here.

create function trx_workdays1(@p_startdate datetime, @p_enddate datetime) returns integer as

begin

declare @startdate datetime

declare @enddate datetime

declare @dowSat int

declare @dowSun...

Happened to me as well. Now watching my time when posting.

One other strange thing that happened was that hitting the post button got me a page with a really nasty...

Right! My confusion about 'full joins'.

Yes, nice indeed. But I was surprised to see this strange difference in results between using the old full join syntax vs the new full join syntax. The new full join syntax produces...

Well, here is something that should get you started. Doing a

select min(sval) from split('Q406/Q305/Q507/Q104')

returns Q104.

I'll leave it up to you to handle mixed delimeters and variable length items.

create function split(@s...

This seems to work:

select distinct t.visit,t.state

from t

  join

  (

  select visit,max(state) state

  from t

  group by visit

  ) m on t.visit=m.visit and t.state=m.state

I would be curious to know how you do these mount points. Is something you do in SQL Server?

In any case, the last time I had to deal with a...

This kind of vertical to horizontal rotation has no generic sql solution. It can be done for specific situations using case statements. Thus your data can be handled by the following...

Taking your data (to which I have added an extra bike record - to make things interesting) you want a query that produces a result like this:

productid   partdes                            bikedes                       

-----------...

You might want to look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=317151

where there is a very similar problem.