GSquared (3/20/2009)

---

Better yet, in most cases, is don't log inserts, just log the "deleted" table for updates and deletes, and then the current state of the row is your new...

I think the only way you could fix this is to force a page break after a certain # of rows as the table will grow based on teh #...

They look okay to me as far as coding goes. In addition to the articles GSquared posted you may want to check out this one[/url] too.

I do have a...

Hey, I think I almost understand it now. It's an xml doc without tags and since the XML is returned in one column you now have a delimited list.

Makes...

Lynn Pettis (3/19/2009)

---

It's the FOR XML PATH part that I am not really sure about myself. That's why I was asking for some help here. I'd like to...

Lynn Pettis (3/19/2009)

---

Okay, I can use stuff((select ', ' + cola from dbo.table1 t1 for xml path ('')), 1, 2, '') but I sure can't explain the how's and why's....

Here's an example that shows how ownership chaining works in addition to the link Matt provided:

-- drop objects if they exits

IF OBJECT_ID('test.test_table') IS NOT NULL

...

No problem. And a question only seems silly once you know the...

Try this (no guarantees):

Iif(FlagCol = "Flag",Nothing,AmtCol)

If you mean something like this:

Update table

Set columnA = Sum(columnB)

Group By

columnC

Then No.

Can you give some more information on what...

You should definitely try the solution proposed by GSquared it will scale and perform much better than a loop.

If you don't have a numbers table you can create a CTE...

It can be done in SSIS, but you have to use a Script Component to do it. Within the Script Component you would use the Split function which creates...

Greg Snidow (3/18/2009)

---

Greetings all. Admitedly, reading "the rant" lead me to this thread, and at the risk of seeming to barge in on a club of which I am...

Lynn Pettis (3/18/2009)

---

I had a disagreement last night with a COACH at a Girls Varsity game over Law 11. He didn't like the fact that I called his player...

Michael Valentine Jones (3/18/2009)

---

It doesn't seem to handle tab indents very well. The indents below are all over the place, even though they are all a single tab character.

I...