There was this one company that had hawaiian shirt days. Ultimately though the company headquarters burnt to the ground.

I know the post is a bit old but I just wanted to add that I've successfully done this and have not seen any adverse issues on both 2008 and...

Ok how about this modification of spaghettidba's code:

SELECT aBunchOfColumns

FROM User_Profile AS p

INNER JOIN aBunchOfTables

ON someCondition

WHERE EXISTS (

SELECT *

FROM...

You could use one update statement per "dataelement".

edit: as usual I could be completely wrong!

create table #task(TaskId bigint unique, Name varchar(2000))

insert into #task values(1, 'Text Text Text Text Text...

I wonder if you could just modify Spaghettidba's criteria to check for the null @tvp maybe?

SELECT aBunchOfColumns

FROM User_Profile AS p

INNER JOIN aBunchOfTables

ON someCondition

WHERE EXISTS (

...

narengc (7/9/2015)

---

I am facing a strange problem in executing stored procedure. Basically my sproc will take a values from Java application and create a Insert statement. Please see stored procedure...

Michael L John (7/10/2015)

---

I've been down that road also!

If you keep going on this thread, as well as others, the "answer" is to drop the trigger, drop the publication and...

Michael L John (7/9/2015)

---

While I know nothing about this, I was just curious if your tables themselves had that ansi padding set? I know I've seen some table definitions that...

Perry Whittle (7/10/2015)

---

patrickmcginnis59 10839 (7/9/2015)

---

I think you had...

Michael L John (7/9/2015)

---

I am attempting to create a snapshot replication publication.

When the snapshot is generated, any table that consists of all numeric columns creates a script with...

I think you had the right solution, if...

patrickmcginnis59 10839 (7/9/2015)

---

try quotes?

$SourceLocation = "e:\backup|xxx'$'xxx\master\Full"

$DestinationLocation = "\\sharebackup\xxx'$'xxx\master\Full"

Not sure if the single quotes inside the double quotes will still escape your $ for you, but you could try with first...

try quotes?

$SourceLocation = "e:\backup|xxx'$'xxx\master\Full"

$DestinationLocation = "\\sharebackup\xxx'$'xxx\master\Full"

Not sure if the single quotes inside the double quotes will still escape your $ for you, but you could try with first and then...

Perry Whittle (7/9/2015)

---

patrickmcginnis59 10839 (7/9/2015)

---

That's true, I don't have to have that functionality in a copy operation, as long as there was some other way to manage the bandwidth that...

That's true, I don't have to have that functionality in...