Is it the same in sys.dm_exec_sessions , though i cant imagine it would be different.

How about sys.dm_exec_connections does that contain the correct ipaddresses ?

It's on my to-do list

You could do worse than asking Jacob Sebastian @ http://blog.beyondrelational.com.

He might be able to point you in the right direction of someone who runs a local training company.

Mines waiting for me to pick up at the local DHL depot.

Hee Hee, No worries Jeff, constructive criticism always welcome 😛

Here's another method (requires 2005+)

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/a-faster-tsql-random-length-random-string-generator.aspx

I tend to avoid table variables, if you get it wrong and use a temp table when a variable would of been optimal then it costs you milliseconds. ...

Seems a bit short sighted...

Forget the function, you dont need it. Is all you want the last 3 edits ?

You havent supplied enough details for me to give an exact solution but something...

Here's an idea.

http://tinyurl.com/ycqnwyd

Be catching the train in about an hour, 3 days of sql nerdness , here i come 🙂

dmounday (11/18/2009)

---

Thanks for all your feedback. I definitely get a sense everyone's negative views on the use of a cursor. The next time I think I need one, I'll...

blandry is correct, obviously data accuracy is the most important thing. Period. If a reports runs in seconds but has the wrong values it's useless. Even after...

Personally the only cursors i have written recently are when my actions are outside of the transactional 'world' of sqlserver, Such as sending emails.

As the queries are the same barring the test for pord_pondcode the below would eb more efficient than two queries.

Also you were grouping by plsup_minord but not selecting it out.

select...