Ed Wagner (12/13/2013)

---

batgirl (12/13/2013)

---

Revenant (12/13/2013)

---

jasona.work (12/13/2013)

---

SQLRNNR (12/13/2013)

---

we crossed back over to positive digits a couple of days ago and...

Lowell (12/6/2013)

---

one of the things that is going to make this slow is the linked server;

the execution plan will end up copying the entire table over to tempdb, and...

asheppardwork (12/6/2013)

---

I don't know why I had a mental block for doing it this way; but this is perfect. All 868 rows returned in less than 1 second. ...

jdbrown239 (12/5/2013)

---

Thank you so much for the reply. I need to mention that the tables application.app_key and apdoc.user1 exist on separate databases (db1.application.app_key and db2.apdoc.user1.). I am running the query...

Steven.Howes (12/6/2013)

---

What's the error?

When you pass a multivalue parameter you have to do a

=join(Parameters!PraramName.Value,",")

I always forget this step, that and forgetting to make my receiving SP variable large enough...

raysteve43 (12/3/2013)

---

We have a large lookup table with 200k records. This table is used frequently in a high volume database. We now have to update that...

dwilliscp (12/5/2013)

---

Thanks, it works for me.. but even though I gave the uses execute access to the SP, it comes up with an error that the job does not exist....

You can do this for all customers in one operation by first aggregating the data by CUSTNMBR and MONTHNBR, then aggregating that data by CUSTNMBR for the whole period.

Here's...

Ed Wagner (12/5/2013)

---

Luis Cazares (12/5/2013)

---

Actually you can use a variable inside IN if it is called from SSRS. The variable is replaced in the query before submitting it to SQL...

Ahh, this brought back bad memories of all the extra typing required to declare and set variables in separate statements. I still say a silent "hallelujah" every time I declare...

Lynn Pettis (11/22/2013)

---

Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this...

Grant Fritchey (11/22/2013)

---

I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk...

kwoznica (11/16/2013)

---

To answer your questions about the DDL. The decimal places chosen was done over 10 years ago and I don't know why. this is a database I now manage...

kwoznica (11/16/2013)

---

Thanks for posting WolfKillJ!

Your code worked really well. Correct me if I'm wrong about the logic behind it.

You create the CTE object to start. In each of the...

fawad.majid (11/15/2013)

---

Hi Jason..

I haven't check the issue with try...catch block.. ill do that ...

Let me add one more thing in this... This procedure/script run through the 69 steps and...