Have you looked into setting up a CMS (Central Management Server)?

Cursor's and Dynamic SQL aren't bad per se but rather can cause issues when not executed properly. Try to...

You have to escape it by adding another single quote.

'James O''Neil'

You can test it out.

DECLARE @TEST NVARCHAR(20)

SET @TEST = 'James O''Neil'

SELECT @TEST

This is how I did it

DECLARE @testdata TABLE (id int, date datetime, Amount int);

DECLARE @testdates TABLE (date datetime);

INSERT INTO @testdata (Id, Date, Amount)

SELECT 1, '1/6/2014' , 21 UNION ALL

SELECT 1...

As Sean has mentioned some sample data would be very helpful here. That being said I have a funny feeling you are getting the same data multiple times because...

You're right about that one...I've been stung by...

This would probably work also but...

Alan's answer works and is nice and clean. I figured I'd add my take since I was already looking into it. Often there are more than a few...

SELECT REPLACE(Address2,'P.O. Box','Post Office Box') AS Address2 FROM CLAddress

https://msdn.microsoft.com/en-CA/library/ms186862(v=sql.100).aspx

better yet...

https://msdn.microsoft.com/en-us/library/ms181984(v=sql.100).aspx

I realize you may not have known about the REPLACE function but the previous posters were trying to push you in...

Just throwing it out there but why do they have to write back to the same DB they read from? I'd have them pull from the read only unless...

I rigged up an example for you before...

I have to give you a thumbs up for providing the sample data and code.

The bad news is your table structure is what's killing you. I'll admit I obviously...

I just...

Ok so if you only care about locating Package Numbers that have a CDI but does not have a POD this should work.

SELECT

Field6 AS PackageNumber,

MAX(CASE WHEN Field4 = 'COLLECTION/DELIVERY INSTRUCTION'...

Try this:

SELECT

u.USERID,

u.NAME,

u.PHONE,

ui1.INFO AS Sport,

ui2.INFO AS Food

FROM

[User] u

JOIN UserInfo ui1 ON u.USERID = ui1.USERID AND ui1.COLUMN = 10

JOIN UserInfo ui2 ON u.USERID = ui2.USERID AND ui2.COLUMN = 30

You need to realize that there are NO duplicates in your sample output. The different DocumentID's make the rows completely unique no matter how much other data appears to...