This video[/url] talks about exactly the problem you're having.

John

How can you have a count on each row? It'll either be 1 or 0 (equal or not equal). Please will you provide some sample data and expected...

Join the two tables on number=number and do t1.sec - t2.sec for the second column of your result set. Make sure you know how you will handle the cases...

james.ingamells (8/8/2013)

---

Hi,

My SQL knowledge is basic to average and need some help in counting rows in a join where 2 dates match:

SELECT MT.[Organisation ]

,MT.[Assignment Number ]

,MT.[First Name ]

,MT.[Last Name ]

,MT.[Position...

Martin

Let me see if I can be of a little bit more help. I'm disappointed, but not altogether surprised, that the code you posted is generated by a Microsoft...

Martin

You're declaring table variables (@tbNames etc), which are materialised in tempdb, and comparing data in them with data in your database, which has a different collation from tempdb. Hence...

P Jones (8/7/2013)

---

I always read the email on my 2 x 1920px wide desktop monitors and since the layout change have given up reading from QOTD onwards as it's just...

What is your question?

John

Martin

Yes, open SSMS, connect to your server, click on New Query, paste the query into the ensuing window and press F5.

I've just re-read your original post. Please will you...

martin 7826 (8/5/2013)

---

Thanks very much Simon. I think I actually understand all of that. Useful!

I'm always happy to follow the easy route so I'll try to change the collation of...

The way you've written it, it will return everything that has 'UK' in. If you lose the first '%' then you'll get everything that starts with 'UK'. Some...

There's a last_execution_time column in dm_exec_query_stats.

John

Same with syscomments, which you should...

You need to use Parameter Mapping or result set, not both. If you use Result Set, the results of your query are saved to a variable of type Object,...

Use an output parameter or result set in your Execute SQL task to get the value into a variable, and then user that variable to configure your data flow.

John