alhakimi (5/27/2014)

---

Dear friend

Thank you for your quick response, i tried that , but two points still need your assistant with is those two tables are from two different databases...

nimalatissa (5/27/2014)

---

Thanks for the reply. it looks to me there is no point in trying to squeeze COALESCE here. Do you see any other way to rewrite this in much...

SQL_ME_RICH (5/27/2014)

---

Hello -

I am in the midst of some database tuning for a CRM 2011 database, and part of that effort is in attempting to get rid of what...

You could also use EXCEPT for this.

select *

from table2

EXCEPT

select *

from table1

Excellent job posting ddl and sample data. Your description is good too. Thanks!!! This makes it a lot easier to work on your issue.

Your description of desired output and the...

nonexistent

SNFU

I agree with Phil. Here is an excellent series of articles about the topic.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

chrismic999 (5/27/2014)

---

This seems to work

SELECT accountname,invoice_date, ROW_NUMBER()

OVER(PARTITION BY AccountName Order by INVOICE_DATE) as RankOrder from dbo.sagesales

where AccountName is not null

Insert help from above

But now I want to update...

chrismic999 (5/27/2014)

---

I have a table where basically I want to identify the first Invoice placed by an account.

In the file I have 2 columns AccountName and Invoice_Date which I order...

adonetok (5/27/2014)

---

This a part of one sp in which there are about 20 select statements.

Of all select statement, they need @headerid and @Providerid value.

If using

SELECT HEADERID, PROVIDERID INTO #HEADER...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

adonetok (5/27/2014)

---

I try to modify a code to create a temp table but got an error.

How to fix it?

------------------------------

Declare @headerid Int

Declare @Providerid Int

BELOW CODE IS WORKING:

------------------------------

SELECT @headerid=HEADERID,@Providerid=PROVIDERID

FROM CLAIM WITH(NOLOCK)...

Which one of the solutions was the one...

I think was...