halifaxdal (12/7/2011)

---

Please don't be tough to Ninja, maybe it was a tough...

Considering the topic of this thread, it should be open for discussion. What I like, sir, is that you are keeping it calm, and logical. You have presented...

You may have to write your own procedure using the CREATE LOGIN statement. Looking at the sp_addlogin in BOL doesn't show anyway of doing what you are asking.

How big is the existing table? Are we talking about a table with billions of rows of data?

Ninja - You'll have to show me what you were trying to accomplish, just not clicking today.

Here is another way to write my query, just requires more typing:

select

...

Why are you trying to partition the data?

Actually, I came up with this:

select

i.SysID,

i.Code,

d.Title,

d.NextReviewDate

from

infosys i

...

Well, with the info provided there really isn't much we can do except add additional guesses to the cause:

Bad execution plan for the given parameters to the procedure

Out of date...

Still missing requested information: DDL for the table(s) involved in the query, sample data for the table(s), expected results based on the sample data provided. As this is a...

Where is the most current actual execution plan?

Could you repost it?

My concern was all the implicit data conversions. Wanted to see if we eliminated that if it would help. Onward and upward.

In the code provided, @MyToMonth is declared but never used. Let's try something.

Give the following a shot, it isn't what I would want in the end, but I...

There are others out...

eseosaoregie (12/6/2011)

---

I have included a copy of the execution plan for the stored procedure.

Can someone show me how to do the multiple pivot synatx and I will give that a...

eseosaoregie (12/5/2011)

---

Apologies for the late response. i had a delay on my train home. I will try and fill in the blanks.

With regard to the TradeDateKey it is an INT....