Thomas (4/15/2009)

---

Actually, not true. In my tests the above solutions at best matched the cursor or were beat by it and the cursor certainly...

Thomas (4/14/2009)

---

Agreed. Here's another example. You want to build a numbers table that simply contains a series of sequential integers. There are many uses for such a table in...

RichardB (4/9/2009)

---

Only...

Hi RichardB,

you could...

".....but we've always done it that way"

"No need for that where clause, we can filter the results in the GUI"

Regards

GermanDBA

Graspnext (4/6/2009)

---

Just to say that my idea about configuring the publisher to use the distribution database on the subscriber is fatally flawed when (as in my case) you have more...

Hi Sean,

doesn't peer-to-peer do this anyway? IIRC the distribution is set to be performed on the source machine as default. I would suggest that you try it out...

Hi Jack,

I agree with the safety of db_mail, just thought it prudent to point out that doing things like that inside a trigger can be a little risky. Trigger...

Hi Jfc,

I just noticed that my sample code didn't have the html code in it - the forum seems to have thrown it away (doesn't like html tags to...

Hi Jfc,

have you tried creating the template you want with all the html tags in it and then using REPLACE to remove your placeholders?

Example:

declare @htmltext varchar(max)

declare @username varchar(255)

declare @calldescription varchar(255)

declare...

Hi Steve,

this is something that I have seen at my new workplace.

It is not just cross apply that can cause the problems, joining directly to XQuery or OPEN XML queries...

Hi Ian,

no problem.

Do let us know how you get on.

GermanDBA

Ian Ashworth (2/16/2009)

---

At first thoughts for data transfer I immediately looked into BCP (as I'm from a SQL 2000 background) however I soon came to realise that due to the...

Hi there,

maybe this can get you started:

-- Testdata based on your posted example did not work on the forum, it needs inserting here

declare @xml xml

set @xml='your xml data here'

;

-- Shred...

Hi again,

just in case anyone is interested, I got in touch with the author of the whitepaper and he has this exact topic in an up-coming blog!

He also asked me...