Here's...

Both databases have 'ANSI Padding Enabled' set to false.

Read the following article. It will solve your problem. http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Or, if you post some DDL and sample data we can give you better help 🙂

Do you want the results in order by the color id?

Or do you want the results returned in the input order?

Personally, I have found that one of the best ways to learn T-SQL is by reading through the posts on this site. 🙂

I come on here every morning, read the...

Sure it is. But I'm still not clear on if the OP wants...

Jeff Moden (7/9/2008)

---

I haven't executed it (the last part of the code), but it looks correct. The first part of the code still has a "Dense_RANK" in it... 2k...

Sorry, I missed that. :blush:

Will this work?

DECLARE @Table TABLE

( BatchID INT

,TransactionID INT

)

INSERT INTO @Table

SELECT 101, ...

Try this:

DECLARE @Table TABLE

( BatchID INT

,TransactionID INT

)

INSERT INTO @Table

SELECT 101, 1

UNION ALL SELECT...

harshil, you obviously have not read the requirements at all.

I think barry has done an excellent job explaining:

rbarryyoung (7/1/2008)

---

Except...

pradeepkk2003 (7/7/2008)

---

Hi Jeff,

Thanks for your reply. The start date and end date are selected by the user, so what if he selects 1st July and 3rd July , will your...

Almost.

FULL OUTER JOIN =

RIGHT OUTER JOIN

UNION ALL

LEFT OUTER JOIN

- duplicates

Try running these two queries to see what I mean.

The second produces duplicate rows, while the...

sead.j (7/3/2008)

---

I didn't look details, but now I see that your code is (almost) the same - just remove '@' before Employees and Orders.. that's all...

BTW. Now I'm breaking my...

Hmm... I don't see a difference between my code and yours.

What's different about yours? :ermm:

Here's Steve's answer using 2 temp tables and a loop.

I couldn't get the CTE to work properly.

DECLARE @Results TABLE

(

Title varchar(50),

CustomerId nchar(5)

)

DECLARE...