What's an interview question that has thrown me for a loop?

"Can you give me an example of when you have failed ?"

Totally unexpected - turned round with something along...

Think you will have to write custom code within SSRS - below a couple of artricles that should give you a starting point.

http://msdn.microsoft.com/en-us/library/bb395166(v=sql.90).aspx

http://techfilth.blogspot.com/2008/07/calculate-median-on-group-in-ssrs.html

The statement below shows you how to return the numbers of minutes, so you could use this in your where clause where the number of minutes was not between 690...

from my code snippet - change the from clause to point to your table 🙂

;with cte as (

select *

...

But you do have a fuller explanation... 😛 and therefore a more complete reply - curse my haste !!

Think this does what you are after - let me know if not D..

declare @ccTest table (

localID varchar(50),

STDate varchar(10),

enddate varchar(10),

CCAC int)

insert into @ccTest Values ('57180', '20110601',...

One way to accomplish this is to change the data access mode of the oledb source component from Table or View to SQL and write the statement in...alternatively you could...

Think you can only do this with a dynamic pivot statement - could be wrong though - take a look at the following article[/url] by Jeff Moden - think this...

Maybe not the most efficient way, but you can achieve this using recursive ctes

declare @data table(Col1 varchar(5), Col2 varchar(5), Col3 varchar(5), Col4 varchar(5))

insert @data

select 'ABC', 'XXX',...

Was missing the nulls previously...slight revision

SELECT * FROM #Cartesis_to_hfm

WHERE (D_OT <> 'IM06' and D_TE <> 'TM06')

or (D_oT is null And d_te is null)

or (D_oT <> 'IM06' And d_te is null)

or...

not sure if I am missing something - have you tried

SELECT * FROM #Cartesis_to_hfm

WHERE (D_OT <> 'IM06' and D_TE <> 'TM06')

?

Again - without more information about your tables it is not possible to say...also, you original question is a little vauge and raises more questions...such as what bonus to apply...

Would need much more information before it would be possible to help - is all the information in a single table or multiple tables etc etc

Great - thanks for the link Steve

Nice - the client stats for the two appear to be the same - any idea if with greater volumes yours would perform better ?