Swing

Bono

I did think your question was over-thinking things with CASE statements in there. You're right, MIN() won't work. Can you post some sample data please? This...

Depending on what you're trying to to select MIN(datecolumn) will do it.

I should have been clearer about the potential risks, although I'll admit to forgetting completely about QUOTENAME.

In VERY simple terms:

declare @tablename varchar(50) = 'YourTableName'

declare @SQl Nvarchar(4000)

set @SQL =

N'select * from '+@tablename

exec(@SQL)

That's what I took from BOL and got the question wrong.

Ed Wagner (1/6/2015)

Silly me - I still use minutes in...

Ed Wagner (1/5/2015)

CELKO (1/5/2015)

I've actually got a few recipes that call for equal weights of eggs and other ingredients. You weigh the eggs in the shells then match the...

It would be funny though, to change recipes to call for 25 grams of egg yolk fully encapsulated by 33.7 grams of egg white instead of just calling for "1...

Polish

I'm really not sure what you want to do here but it's best to include the columns you want by name rather than using SELECT * and trying to exclude...

ChrisM@Work (1/2/2015)

Query 1 (insert into #temp_violation etc.) has an odd filter:

and

(

cast(fh.startdate as date)<= cast(tv.startdate as date)

and

cast(fh.startdate as time)<= cast(tv.startdate as time)

)

This will capture datetimes from fh where they...

ChrisM@Work (12/31/2014)

Have you considered using EXISTS No I hadn't, see my earlier comment about being a noob 🙂 The fact it ran at all...

I've finally got back to this after the Christmas break and a brief sojourn in proper work.

Thanks for your advice gents. I learned something very useful about execution...