Check out the following code:

CREATE TABLE [dbo].[TableA](

[fileID] [int] NOT NULL,

[langId] [int] NOT NULL

) ON...

Noticed one thing, make it a select distinct on the outer select.

Hope the following test code helps you out:

create table #TestTab (

Col1 int,

Col2 int

);

insert into #TestTab

select 4352279, ...

Chris Rogers (11/24/2008)

---

A little addition here. I was, obviously, having this problem as well. Here is an example of what my proc looked like:

CREATE PROC Reports.MyExampleProc

@StartDate DateTime,

@EndDate DateTime

AS

IF(@EndDate...

Could be that when the optional parameter is missing, the query in the stored procedure is using an inefficient query plan.

Okay, got it now!!

create table #TestTab (

Col1 varchar(10) null,

Col2 varchar(10) null,

Col3 varchar(10) null

);

insert into #TestTab

select 'First', 'Second', 'Third'...

Okay, with a minor change, this should work:

create table #TestTab (

Col1 varchar(10) null,

Col2 varchar(10) null,

Col3 varchar(10) null

);

insert into...

Sorry, but the code I posted isn't quite right. If Col3 is null or Col2 and Col3 is null, you end up with a ',' at the end.

Does this test code help you out?

create table #TestTab (

Col1 varchar(10) null,

Col2 varchar(10) null,

Col3 varchar(10) null

);

insert into #TestTab

select...

Jack Corbett (11/24/2008)

---

rbarryyoung (11/24/2008)

---

Jack Corbett (11/24/2008)

---

Lynn Pettis (11/24/2008)

---

Jack Corbett (11/24/2008)

---

rbarryyoung (11/24/2008)

---

And for the record, I like to sit up front because at my age, I cannot see the code slides...

am (11/24/2008)

---

Guys,

I have to generate monthly payment schedule from the below information

NoofPaymentsTotalAmtContractNumstartdayofmonth

4454214

Based on the above information the schedule should be generated starting 4th day of next month, payment amount rounded...

Try the following in a test environment:

--TableA (Source)

--

--ID AgencyCD AgencyCostCD EffDate ...

Try this in a test database (sandbox if you will).

CREATE TABLE dbo.Table_1

(

MyColumn1 int NOT NULL,

MyColumn2 int NOT NULL,

MyData1 varchar(50) NULL

) ON [PRIMARY]

GO

ALTER TABLE dbo.Table_1 ADD CONSTRAINT

PK_Table_1 PRIMARY KEY CLUSTERED...

george sibbald (11/24/2008)

---

approaching from a different angle................

what EXACT version of SQL are you on? I would be surprised if you had come across a new bug after all this time....

am (11/24/2008)

---

Guys,

I have two tables one destination and the other source, I am trying to import the data from the source but I am unable to build

the SQL to...