Read this for better help: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Any suggestion at this point, would be a wild guess.

I guess you could generate a .regsrvr file. Here's an article on exporting it https://www.mssqltips.com/sqlservertip/2015/import-and-export-registered-sql-servers-to-other-machines/. If you write the code to generate the xml for all the servers, you could...

A filename can't contain colons.

You're right Sean, I missed the blank value part.

I also prefer your solution as it should imply less work for the server.

What if you remove the +":"?

Insert the comma in the ISNULL function.

SELECT DISTINCT STUFF(

(SELECT (ISNULL(', ' + t2.Name,''))

FROM #Temp t2

where t1.ID = t2.ID -- t1.DeliverableITEP = t2.DeliverableITEP AND t1.GeoMarket = t2.GeoMarket AND t1.Segment = t2.Segment...

And yet another option:

SELECT DATEADD(MM, DATEDIFF(MM, '19020401', GETDATE()), 0)

John Mitchell-245523 (7/21/2016)

---

This will return 1st April from the year two years before the given date. If you need the date presented in a particular way, do that in...

Phil Parkin (7/21/2016)

---

Really? Then unless your answer is along the lines of

"This cannot be done, unless a column exists on which to order, because...

Y.B. (7/20/2016)

---

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on the other hand at least...

Easy,

Quotes(‘&’) should be replaced with single quotes (').

Double quotes (”) should...

The best solution you can have is to normalize your data.

You should already know how to properly ask questions here.

The foreign key should allow you to prevent truncates. To prevent dropping tables, you can use the a DDL trigger.

CREATE TABLE TriggerTest( id int)

GO

CREATE TRIGGER T_Avoid_Drop_Table ON DATABASE

FOR DROP_TABLE

AS...

mw112009 (7/20/2016)

---

To: RVARN:

Example -

ALTER TABLE employees

ADD CONSTRAINT check_value

CHECK (fieldname IN ('Y', 'N', NULL));

--The above does not work. It allows any value. The trick is you need to take...