Using looping / cursoring in SQLServer , is very much frowned upon as its slow.

*Sometimes* its the only way to do things but not here.

Is it a single character that...

Yes, yes, yes , absolutley. If you want...

Hi ,

try this article

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Google ( or Bing 😉 ) is your friend on this one

http://www.bing.com/search?q=The+operation+has+been+cancelled+due+to+memory+pressure

Not enough details im afraid,

try this article to help us to help you....

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

IMO a calendar table is pretty much essential

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Please keep to one thread

http://www.sqlservercentral.com/Forums/Topic1169158-392-1.aspx

Use the rownumber function to create a unique row number for the starting / ending times.

Then use pivot functionality , i would prefer a manual pivot as shown here...

Adam Machaninc's who is active proc would be a good starting point

I think this is the latest version

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx

Hi ,

you should find this post interesting

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Two issues :

1) If you are using 2008, use the spatial functionality.

2) The sql is non-sargable , every store has to be tested to see if the distance from...

Hi , try this link

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Fal (8/8/2011)

---

Just to bring this thread back on topic, I was told by an MVP that a few years ago Microsoft awarded MVP status to anyone who was running a...

Gianluca Sartori (8/6/2011)

---

WayneS (8/5/2011)

---

Good luck! (I have to admit that...

As ever, I shall be there, Steve *should* be too.

Be interesting to see how they top Brighton