You may want to consider rewriting this process using SSRS. The Web Assistant procedures have been deprecated and I don't believe they exist in SQL Server 2008 or later.

Hope this helps get you started. Not enough in your original post to really provide you with all the code you need.

with Tally12 as (select n from (values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12))dt(n)),

RunningCalendar...

George M Parker (10/11/2013)

---

Please check out the bottom of Jonathan Kehayias's blog page below:

http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

To know whether your value is good or bad, you have to know what "normal" is. That...

Been over a week, I guess you don't need any help.

update yourtable set

gender = case when gender = 'male' then 'female' when gender = 'female' then 'male' end

Ed Wagner (10/9/2013)

---

Lynn Pettis (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on a retainer...

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on a retainer for 5 hours a...

The comparison is not one character by character. Take out a dictionary, find the word axe (starts with ax). Every word after axe is "greater than" and every...

Jeff Moden (10/6/2013)

---

Greg Edwards-268690 (10/6/2013)

---

But they have phone...

Well, I will see what I may be able...

If you would really like some help with this, how about posting the DDL for the tables, some sample data for each of the tables, sample inputs for the procedure,...

Tava (10/3/2013)

---

Hi All,

I need some help! firstly to tweak my results to work as I expect it to & secondly provide an alternate method if my logic is not best...

shad.saleem41 (10/4/2013)

---

Hi

I created a table

CREATE TABLE IdentityProducts(

productid int IDENTITY(1,1) NOT NULL,

productname nvarchar(40) NOT NULL,

categoryid int NOT NULL,

unitprice money NOT NULL)

I want to insert values into it with...

Thank you all for your responses. You have confirmed what I believed to be correct and have passed this on to my supervisor who is satisfied with what I...

Greg Edwards-268690 (10/3/2013)

---

We had separate media with our select agreement.

Since they were pre-keyed, I never paid attention to the keys.

I would expect since SharePoint had 1 media, and the key...