Scott,

Interesting Idea!! Still I would like to see 'sample numbers'. It is nice to know that there is a choice

Hope that it flourish!!

Don't like the idea for several reasons.

Constraints (all kinds) are lost, indexes (all kinds) are lost and the network will be really taxed if the DB grows at "decent" sizes. By...

CREATE proc ben_sp_bringBackConsultantNull

@daterequired datetime,

@consultancytypeid numeric(9),

@level tinyint,

@clientid numeric(9)

as

SELECT top 10 (left(Thedate,11) + ' - ' + consultantname ) as 'Consultant Name', Thedate 'Date'

FROM WeekEndsAndHolidays, vw_consultant_ability

WHERE dayname <> 'Saturday'

AND dayname <>...

I N V E N T O R. Hands down!!

I am graduated from EE and Automation and Control systems. I would have love to invent many of the cool things I...

Actually I am on the same boat as Jamie. I don't receive the emails a regularly as I used to!!

Cheers,

select datediff( hour, '1899-12-30 20:00:00.000','2006-04-05 20:14:19.000')

Returns: 931488

The number of hours between the two dates. That, is why the query you posted returns 0 records when you used datediff(hour, tz.stop1, h.calldatetime)...

Howard,

Sorry I couldn't get back to you sooner.

try:

select

    sum( case when Control_code ='B' and NextControl_Code <> 'E' then 1 else 0 end) as BwithNoFollowingE

  , sum( case when (Control_Code=...

Rob,

All I have to say is that I haven't laught this much in a loooooong time

if we are talking about 5 - 7 millions I still think that the calculated column (with an index) will be a lot faster for two reasons.

1.The value is an...

Sure I do too!!!

I have learnt a lot on this comunity

Here you go:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Sorry but this was the post:

LEN(RTRIM(LTRIM(ERR))) > 0

is equal to

LEN(ERR) > 0

and that is not correct. Len ignores trailing spaces but not the begining ones.

select Len ( '  Space...

Well I have to say....  that is not really exact:

select Len ( '  Space in the begining '), Len (rtrim(ltrim('  Space in the...

How many rows are we talking about here?

Howard,

No problem, we(at least I) pretty much come here for two things: to help and to have fun solving the problems people post

Cheers,