Here is some code for you to review. Ask yourself questions about the code, then try to answer them yourself by seeing what is happening.

I am using dynamic sql...

morepainot (8/1/2012)

---

•Do all staged tables exist in the source and in the stage database?

•Do all staged columns exist in the source and in the stage database?

•Is the data type of...

I'm going to go back to square one. I have been rereading this thread and I am just getting confused and I need some illumination.

What is the purpose of...

Hard to trouble shoot when we can't see what you see.

Care to post the code and any other info that may be important, like error messages?

morepainot (8/1/2012)

---

Okay, understood. This code is really long but Im going to post it with all the errors, mostly fixed. This included the procs usp_PreStageValidation and usp_PostStageValidation

ALTER PROCEDURE usp_PreStageValidation @ApplicationName...

Take this as a "seal" (imagine a picture of a seal here) of approval? I can't...

morepainot (8/1/2012)

---

Ok, I took care of those errors. Now the only errors I am getting are

"Msg 2714, Level 16, State 3, Procedure usp_PreStageValidation, Line 185

There is already an object...

Took the code from above, added GO batch separators between the CREATE PROCEDURE statements.

Also, again, when posting code please use the IFCode [ code="sql" ]/[ /code ] shortcuts (WITHOUT the...

I made a slight change to the function Chris wrote. I changed it from a mtvf to an itvf. Please check it out.

CREATE FUNCTION [dbo].[GetCIDs2]

(@SID INT)

RETURNS TABLE...

anthony.green (8/1/2012)

---

There is a mistake in the view in the database, got a bit delete happy with obfuscating the view.

The line

join StandardsGroupsClassification ccmap

ON ccmap.PID = s.SID

should be

join StandardsGroupsClassification ccmap...

anthony.green (8/1/2012)

---

Sorry all, went on holiday, just back on with this now.

I have created a database and backed it up which you can download from here

http://antg.dyndns-home.com:8080/myweb/other/joiner.bak.

It contains the tables with...

Abel A. (7/31/2012)

---

The last 8 "Minimum Qualifications" look like padding to me.

Let's analyze your situation, you're not getting any good DBAs and yet you're still standing firm on your...

ramkumar1336 (7/31/2012)

---

We have situations in our application where the 1st business day of September of

specified year is the due date for a tax bill. Write a user defined function in...

Do you mean something like this?

create table #TestTab (

TestTabId int identity(1,1),

TestName char(1)

);

insert into #TestTab(TestName)

values ('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t');

go

declare @InputString varchar(128) = '1,3,2,5,5,4,3,2,2,1';

select

...

Slight change to the code:

CREATE TABLE [dbo].[tblInvoice](

[intID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[intCustomer] [int] NULL,

[intMonth] [int] NULL,

[intYear] [int] NULL,

[monAmount] [money] NULL,

CONSTRAINT [PK_tblInvoice] PRIMARY...