Steve Jones - SSC Editor (7/26/2013)

---

Jeff Moden (7/26/2013)

---

BWAAA-HAAA!!! I've got tons of hair. I'm just...

octavuslimited (7/19/2013)

---

I have seen various posts showing interest in being able to perform simple queries and execute storedprocs on MSSQL using a web browser. I had a similar interest so...

Grant Fritchey (7/19/2013)

---

I was doing some research this morning and got sucked down a rabbit hole (it happens) and landed on a series of sites complaining about Stack Overflow and...

Khalid Hanif-458693 (7/16/2013)

---

patrickmcginnis59 10839 (7/16/2013)

---

keebler96 (7/16/2013)

---

This is the...

keebler96 (7/16/2013)

---

This is the problem. There is...

Khalid Hanif-458693 (7/16/2013)

---

The columns would be

prevcostcenter, prevpaymentcode, previnvno, nextcostcenter, nextpaymentcode, nextinvno

I have tried the rownumber the estimated rows in the execution plan is always the total rows Iin the...

RobertYoung (7/15/2013)

---

patrickmcginnis59 10839 (7/15/2013)

---

RobertYoung (7/15/2013)

---

patrickmcginnis59 10839 (7/15/2013)

---

Vila Restal (7/12/2013)

---

That's a sweeping generalisation of 'coders' (or perhaps more respectfully called software engineers or developers). Do you really have so little respect...

RobertYoung (7/15/2013)

---

patrickmcginnis59 10839 (7/15/2013)

---

Vila Restal (7/12/2013)

---

That's a sweeping generalisation of 'coders' (or perhaps more respectfully called software engineers or developers). Do you really have so little respect for them all,...

Vila Restal (7/12/2013)

---

That's a sweeping generalisation of 'coders' (or perhaps more respectfully called software engineers or developers). Do you really have so little respect for them all, even those you've...

You could treat the parameters of your report as update requests and send these parameters to a stored procedure.

select substring(name,charindex('gr',name),2)

from ...

worked for me!

ben.brugman (6/11/2013)

---

patrickmcginnis59 10839 (6/11/2013)

---

I got something similar to work, LOL at the quotes needed, plus it doesn't seem like "Initial Catalog" is any help, but I put it in there...

I got something similar to work, LOL at the quotes needed, plus it doesn't seem like "Initial Catalog" is any help, but I put it in there anyways:

SELECT * INTO

#TMP1

FROM

OPENROWSET...

The query looked ok to me (well except for the 'count' clause, not sure how thats working in isolation without an accompanying 'group by'). You might want to double check...

You need to match the keys in both tables!

select T1.[History_Key]

FROM

LOAD_SCHED as T1

WHERE NOT EXISTS (SELECT distinct T3.[Archive_Key] FROM Archive_LOAD_SCHED AS T3 where T1.history_key = T3.archive_key)