I may have taken the requirements a bit too literally here, but anyway, here's my shot at it:

SELECT [Case Number] = case_number,

...

SELECT CONVERT(DATETIME, '19000101', 112);

Tasnim,

Do you get any rows returned from the following query?

SELECT AppName, AppVer, AIT_ID, COUNT(*)

FROM Master_Application_List

GROUP BY

...

Try using the Wizard I mentioned to generate the data (it's the test values I'd like, not just the template INSERT statements). Don't worry too much if you can't.

Thanks. If you could provide a few rows of INSERT statements for the test data that would be great too.

(Right-click the database, Generate Scripts...and make sure you select Script...

You can script the table definitions out using Management Studio 🙂

It will also script the data if you set the options right.

Otherwise, it's just too much work to try to...

If the restrictions I mentioned don't apply, the following extension of Adam's code illustrates a single-step alternative:

Setup:

USE tempdb;

GO

CREATE TABLE dbo.MasterRecord

(

...

Adam Haines (7/21/2010)

---

Since we have a known number of columns, we could technically split the data via a split function and then use PARSENAME to split the other data for...

*SMACK*

Just kidding 😀

Funny :laugh:

I had to...

mpradeesh,

It would help if you could provide some sample data to illustrate exactly what you want to happen.

There are a number of alternatives.

Be aware though that using the OUTPUT clause...

There are a few things to sort out there - could you please post the CREATE TABLE statements for each of the tables involved? It would also help a...

I disagree. It's perfectly possible to sit down with people to talk...

This demonstrates one way the problem can arise:

-- Demo tables

DECLARE @T1 TABLE (A INTEGER NULL);

DECLARE @T2 TABLE (B INTEGER NULL);

-- Add rows with values (1, 2, 3) to table A

INSERT...

:laugh: