Jeff Moden (8/10/2012)

---

I think "The Thread" finally broke. I'm setup for 50 posts per page and this page has seeming randomly selected (but in temporal order) posts from Jan...

I think someone wrote an article about this problem. Search this site for "gaps and islands" and you should find it.

John

I think the point is that there's no such thing as...

If you have a blank (''), then you want to lose the CHAR(10) so that you don't end up with a blank line, so use a CASE expression to deal...

My apologies. I performed a visual inspection but didn't actually test it. Try it with '11 Village Green' and 'Greenford' instead.

John

Yes, that works for the sample data provided (although the cursor isn't necessary) but what happens when you have '11 High Street' and 'Chester-le-Street' as your address1 and address2?

I think...

No, you don't need to iterate or use temporary tables. All you need is a fairly simple GROUP BY query. Please give it a try, and post back...

Satish

The first thing you should do (even before you post on a forum like this) is to type that error message into your favourite search engine and see if you...

Satish

How did you create the SATISH account? Is it a SQL account or a Windows account? What message is appearing in the SQL errorlog when you get the...

Satish

Log in as Administrator and create a login for your own user account. Then log in with that user account and connect to SQL Server.

John

The performance object is called SQLServer:User Settable and the counter is called Query. I can't remember how you get the query into the system and I'm afraid I don't have...

Maybe I'm using the wrong name - it's actually called Performance on my machine. It's what you referred to as PerfMon. Sorry, I should have checked before posting.

John

If I remember correctly, you can create a customer counter in System Monitor with your own query.

John

Back up the tail of your transaction log.

Restore your database from the most recent good backup, with NORECOVERY.

Restore the transaction logs up to the point immediately before the corruption occurred.

Recover...

Anthony

Just declare a variable and concatenate in one single SELECT statement, something like this (not tested):

SET @MyVariable = ''

SELECT @MyVariable = @MyVariable + ', ' + MyColumn

FROM MyTable

ORDER BY MyKeyColumn

--...