momba (1/25/2013)

---

Sean Lange (1/25/2013)

---

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will cache your execution plan...

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will cache your execution plan and more importantly...

jeff-weigang (1/24/2013)

---

Here is some sample data to help with what I'm trying to achieve.

TransDate GroupCode Symbol Price

1/21/2013 ...

No problem. It is hard...

This will work but do you really have no primary key?

Insert script:

INSERT INTO [comparison].[dbo].[tablep1]

...

This should be reasonably close...not sure what columns you are using to determine if it exists.

select iNumerator, iDenominator, vShortName, VORGCODE

from Table2

where NOT EXISTS

(

select iNumerator, iDenominator, vShortName, VORGCODE

from Table1

Where Table1.iNumerator...

Can you post ddl (create table scripts) and sample data (insert statements)? Something so we can create tables and data locally?

You absolutely do not need a single cursor, let alone nested cursors for this. You need to use a calendar table. Just do a quick search on this site and...

Can you post ddl (create table scripts) and sample data (insert statements)?

I don't understand why the output would be only the one row. None of the rows you posted are...

dclemens (1/23/2013)

---

Sean Lange (1/23/2013)

---

Your query doesn't produce any results because it has a table called manpowerprofile? If I comment out that table it returns a single value - 26. This...

What a completely bizarre requirement. However you did provide very easy to consume data!!! A solution here is not really too bad. Just add the next character into your CTE...

Your query doesn't produce any results because it has a table called manpowerprofile? If I comment out that table it returns a single value - 26. This is consistent with...

The kudos belongs to Michael Higgins. He provided the solution. I just suggested a way for you to fit it in with your system. 😀

s_osborne2 (1/23/2013)

---

Hi,

Thanks for you help.

I've been playing with this, and you're right it does work but doesn't give me the solution to the problem i have. I've given @table as...

dclemens (1/23/2013)

---

Hey everyone! This is my first time posting here (please go easy), but I've been using the site for a while now as a reference.

I've been working on a...