You aren't big on providing information today. Given the excellent ddl and sample data provided by Neeraj can you tell what the relationship between these tables is?

I think it is...

So given the input of "201303" what should the output look like.

I have to say that I am still pretty unclear about what you are trying to do here.

Hi and welcome to the forums. 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...

Simply repeating a vague explanation and a table of unformatted gibberish does not explain what you want. You need to explain what the logic here is. We don't know your...

Chrissy321 (6/19/2013)

---

I appreciate you spending any time on this at all since it seems like a data issue,

Below is more representative of the situation. Removing the WHERE statement and the...

Well then you have something else going on. We are at an extreme disadvantage since we don't know your table structures.

The following code works just fine.

if OBJECT_ID('tempdb..#MyData') is not null

drop...

Like this:

SELECT A.id_number, B.notes, B.status, C.location, C.item

FROM TableA as A

LEFT JOIN TableB as B ON A.id_number = B.id_number

LEFT JOIN TableC as C ON A.id_number = C.id_number

With a file that large you should take a look at BULK INSERT.

http://msdn.microsoft.com/en-us/library/ms188365.aspx

OK I looked at your original post over and over and I think I figured out what you are asking. See if this query is close to what you are...

Well we certainly don't want...

I am pretty sure you are looking for something more like this.

--first we have to create the tables

declare @Tables nvarchar(max)

select @Tables =

(

select 'create table IDT_' + cast(IDT as varchar(25))...

Is there a question here or are you sharing something?

Ouch, you have scalar functions calling scalar functions. This is serious performance red flag. Scalar functions are notoriously bad for performance. Even worse when they get nested.

NO we need to have actual DDL and sample data. As I said previously in the form of insert statements. I should be able to hit F5 and have a...

What is the purpose of this? This is going to require some pretty complicated dynamic sql for this.