Antonio:

My tests with XML vs Numbers/Tally table have shown similar CPU time results, but have had interesting IO differences. Did you include IO stats in your runs? (If...

Steve Jones - Editor (4/2/2008)

---

Hate to deviate, but apart from what's put down already, both Windows and SQL auth suffer from the problem that anyone can connect with any application...

TheSQLGuru (4/2/2008)

---

G2, your issue seems to be different in nature from my client's. They took the hierarchy as an initial set of data and then joined it to between...

Jeff Moden (4/1/2008)...

Heh... I know I'm not supposed to cheat, but I do... I maintain the adjacency model... when there's a change move (not just an insert), the whole...

Jeff Moden (4/1/2008)

---

Gosh, I hate the idea of replacing one form of recursion with another, but the recursive CTE will at least handle a set even if it is hidden...

Not sure what you're doing here. I tried this:

create table #TvsRecords (

LastUpdate datetime,

TvsRecordID int identity primary key)

insert into #TvsRecords (lastupdate)

select '4/1/2005' union all

select '4/1/2005' union all

select '4/1/2005' union all

select...

Trader Sam (4/2/2008)

---

If I need a 'select' that has a lot of columns, I'll script out the source table 'create', then manually edit out the extra stuff.

Deleting the...

It looks to me like you're most of the way to where you want to go.

Turn your logic on the Riders into a function, with @PID as an input, and...

This is actually a significantly complex subject.

First, you have to define rules for what "matches any part". For example, "Tub" and "Target" both have the letter "t" in them,...

If there are any null values in the id field in table B, "not in" will return 0 rows. Since "null" means unknown, you're telling to select all values...

I'm not clear on what the end result of this is. I see the tables, I see a the queries, but without a sample of the starting data and...

sblock (4/2/2008)

---

Some of the advantages of using windows accounts:

- Windows accounts can force password changes on a regular basic

- You don't have imbed passwords in programs or force users to...

The article is a reasonably good introduction to the subjects, even though it does have the common flub of assuming table variables are RAM and temp tables are HDD. ...

Try this:

create trigger dbo.updateSettingsTrigger

after update

as

if update(pagename) or update(parentid)

begin

;with CTE (ID, ParentID, Pagename, Breadcrumbs, URLPath) as

(select id, parentid, pagename, breadcrumbs, urlpath

from inserted

union all

select sitepages.id, sitepages.parentid, sitepages.pagename,

cte.breadcrumbs + (breadcrumb string),

cte.urlpath +...

TheSQLGuru (4/1/2008)

---

I have a client with a similar situation. On their system we developed an orghierarchy table that gave both the up and down listing for each org and...