Hi

I prefer the ESCAPE because I think it is more clean but it's your choice 😉

Greets

Flo

Hi

"ORDER BY 1" means to order by "LA.Date" in your statement. You use a LEFT JOIN to your "LifeInfoAgentAudit" table where the "OwnerAgent" is stored. If your first dates don't...

Thanks Lynn! Did something likewise today at work and saw that something...

You wrote "New Database". What about a backup and restore?

Greets

Flo

Hi

Have a look to BOL for LIKE and search for the "ESCAPE" part.

Greets

Flo

I confirm Barry. This seems to be impossible. The best sample was already supplied by Barry but what about comments? Constant text?

Hi

Can't try because there are not test data 😉

Try this:

SELECT

[ColA] = CASE

...

Duplicate. Please answers here:

http://www.sqlservercentral.com/Forums/Topic712399-149-1.aspx

Hi

I got it. You have to specify an alias for the outer table. Since your table name is "holddups" and you refer it within your sub-query you cannot specify "NUM1...

Alvin Ramard (5/7/2009)

---

Jack Corbett (5/7/2009)

---

Lynn Pettis (5/7/2009)

---

Has anyone else noticed that EVERY TIME a new version of SQL Server is released there are many questions asking if you can restore...

mjarsaniya (5/7/2009)

---

--USE THIS ONE

BEGIN TRANSACTION

SELECT * FROM UserStats WHERE UserID = @user-id

IF NOT EXISTS (SELECT * FROM UserStats WHERE UserID = @user-id)

BEGIN

INSERT INTO UserStats (UserID) VALUES (@UserID)

END

...

Google is still down

http://www.sqlservercentral.com/Forums/Topic711917-145-1.aspx?Update=1

Edited: Typo

http://www.google.de/search?hl=en&q=sql+server+2008+what%27s+new&btnG=Search

http://www.google.de/search?hl=en&q=sql+server+2005+what%27s+new&btnG=Search

Hi

Do you mean something like this?

DECLARE @t TABLE (Ip VARCHAR(20), Txt VARCHAR(30))

INSERT INTO @t

SELECT '10.1.30.48', '3GPM'

...

Thank you guys. I really thought I'm a bit slow on the uptake 😛