sayedkhalid99 (10/1/2012)

---

the rule here is we have month no here.

1. check secondmonth amount

2. sum(second month amount) > sum(first month amount)

3. get the difference

4. difference is greater then sum(first month...

Is the other database on the same server?

What change did you make that stopped it working? Was it adding the reference to dbo.Y_name?

You could try setting @MyNumberReturn to null instead of '000000'.

Then you'd only need to check if it was null:

if object_id('tempdb..##tmpSlsTaxOrdsDtl') is not null

drop table ##tmpSlsTaxOrdsDtl;

create table ##tmpSlsTaxOrdsDtl

(

OrderNo varchar(6)

);

--insert ##tmpSlsTaxOrdsDtl values...

There must be a difference somewhere, so you'll need to have a think about it & look carefully.

You can't join on null, because null means 'no value'.

FROM a LEFT OUTER...

OK - Using the code below, I'm only getting 7 rows - the rows from price_2, with deal_2 joined in with data or nulls where the join key is null.

Can...

The join is on isin, but the data in isin from table deal_2 is in cusip in table price_2.

Isin in price_2 is data like M70S.

Pin

There's a problem with the test data. Using your original table layouts, the data doesn't match:

On price_2, price_id doesn't accept null.

Also, cuisp is too small (9) for the data...

Can you give us some sample data - it sounds as though you haven't got any data in your keys.

Is this specifically a 2012 problem - does it work in...

Solution incorporating the above suggestions (thank you):

--====== TEST DATA =============

IF OBJECT_ID('dbo.tblHTML') IS NOT NULL

DROP TABLE dbo.tblHTML;

CREATE TABLE [dbo].[tblHTML](

[RowId] [int] NOT NULL,

[strPage] [ntext] NULL

) ON [PRIMARY]

insert into dbo.tblHTML values (...

laurie-789651 (10/1/2012)

---

This appears to work:

I've elected to show rows where both values are zero in case these are wrong - You can remove this if you want.

I've set MAXRECURSION to...

Bit of a duplicate post?

http://www.sqlservercentral.com/Forums/Topic1366265-3077-1.aspx

This appears to work:

I've elected to show rows where both values are zero in case these are wrong - You can remove this if you want.

I've set MAXRECURSION to 10,...

dwain.c (10/1/2012)

---

dwain.c (10/1/2012)

---

sqlusers (10/1/2012)

---

Hi Guys,

I have created a Default Constraint for my table. But this is not reflected on my table.

EX: Column ImportDate has a Datetime Datatype with NOT NULL...

dwain.c (10/1/2012)

---

sqlusers (10/1/2012)

---

Hi Guys,

I have created a Default Constraint for my table. But this is not reflected on my table.

EX: Column ImportDate has a Datetime Datatype with NOT NULL Constraint.

I...