WiRL (5/24/2012)

---

Hello all,

I hope someone can help me.

I have a table that holds peoples jobs and their deadlines. I want to email the people on a daily basis whose jobs...

not addressing the main point of the post, but in a parent/child hierarchical type query have you considered using the hierarchyid data type..?

i only say this because i saw code...

im curious,

a lot of the resistance to cloud usage comes from a financial standpoint or a good old fashioned control of hardware need... but has anyone looked at this...

michael vessey (5/24/2012)

---

sqlbee19 (5/23/2012)

---

michael vessey (5/23/2012)

---

the multiple rows returned in your select statement are corrupting the @cmd value - in theory the value returned should be correct (although if you...

sqlbee19 (5/23/2012)

---

michael vessey (5/23/2012)

---

the multiple rows returned in your select statement are corrupting the @cmd value - in theory the value returned should be correct (although if you use any...

GilaMonster (5/23/2012)

---

Check your IO throughput. Sounds like the drive is not responding as it should.

Index physical stats doesn't run showcontig, more the other way around. Showcontig is deprecated and just...

Koen Verbeeck (5/24/2012)

---

Schadenfreude-Mei (5/24/2012)

---

Robert Davis (5/23/2012)

---

I laughed very hard at the replies here, but if we're posting serious answers now, I think the OP should start with this post by...

Lynn Pettis (5/23/2012)

---

michael vessey (5/23/2012)

---

ahem.... the tester didn't put the defect...

...anything that necessarily iterates over 1 row at a time and cannot be made to iterate of more than 1 row at a time (you can read that as processes...

oh and a recursive CTE may be an iterative operation, but when cross joined for an insert the "Insert" is not iterative..... it's still a set based operation in the...

Jeff Moden (5/23/2012)

---

michael vessey (5/23/2012)

---

try this

with x (id) as

(select 1 as id

union all

select ID+1 from X as id

where id<10000

)

insert into fooTable

select d.name from sysdatabases d cross join...

ahem.... the tester didn't put the defect there (the developer did)...

see my example

create table footable (name varchar(1000))

go

select 'aaaaa';

with x (id) as

(select 1 as id

union all

select ID+1 from X as id

where id<10000

)

insert into fooTable

select d.name from sysdatabases d cross...

any code before the "WITH x as" must be terminated with a ;

the multiple rows returned in your select statement are corrupting the @cmd value - in theory the value returned should be correct (although if you use any fields from sys.server_principals...