I am assuming that you aren't using SQL Server 2005 since you are mentioning Column Store Indexes.

:blush:

Thanks.

Alvin Ramard (7/8/2015)

---

Sanity? Oh Sanity? Where are you hiding?

I've had it. Enough is enough! When are people gonna stop hiring people that don't have a clue about they're hired...

:blush:

Glad we got it to work finally. I find myself writing a fair amount of dynamic SQL to accomplish various tasks. It is a pain to write and...

How about trying this:

DECLARE @BackupStatement as nvarchar(4000)

,@SQLCmd nvarchar(4000)

,@SQL nvarchar(4000)

,@SourceDBName as varchar(100) = 'AuditTest2'

,@SourceServerName as varchar(100) = 'adasdb'

,@Destination as varchar(500) = '\\clients.advance.local\Data\WIP\test' +...

Or something like this:

with Obsolete as (

select

c1,

c2

from

dbo.tblOld

except

select

c1,

c2

from

...

WayneS (7/8/2015)

---

Jeffery Williams (7/8/2015)

---

Well Close my no cigar. I am trying to parameter the destination server name and I can not get that to execute.

Here is what I am playing...

Have you tried this:

EXEC (@SQLCmd) AT <your_linked_server_name>

Where @SQLCmd is your dynamic backup command?

jcobb 20350 (7/8/2015)

---

I have a table with items, sales locations, and product groups. The product group can be different for each location for the same item. I need to find...

ChrisM@Work (7/8/2015)

---

Lynn Pettis (7/8/2015)

---

Okay, bite the tongue, keep the sarcasm off the thread Silver Spoon just posted. Nothing you can do there but get yourself in trouble.

There, I feel...

You can't mix character data and integer data in the same column.

What are you trying to accomplish? Based...

ChrisM@Work (7/8/2015)

---

select

ColA = CASE WHEN CastableToInt = 1 THEN cast(Data as int) ELSE NULL...

Won't work since the OP wants the numeric values converted to integer values:

select cast(Data as int) from #TestData where Data not like '%[^0-9]%'

union...

Not going to happen since you want to convert the numeric values to integer values.

What...

Okay, bite the tongue, keep the sarcasm off the thread Silver Spoon just posted. Nothing you can do there but get yourself in trouble.

There, I feel a little better.