per Capn.Hector's advice, I am to stick to this thread.

I have a working query. It was given to me by ColdCoffee ( http://www.sqlservercentral.com/Forums/Topic1283875-392-1.aspx ) to solve a major headache...

OK, I got the case statement integrated but the retrieval of tickets by max(revision_number) is still eluding me.

The result set for the above query includes multiple entries per ticket#. ...

Two more things I'd like to accomplish with this.

1. rename the Org field, which in real life is only the name of a column, and it's values, are numbers.

case...

I can't believe it ColdCoffee. I thank you....I want to work where you work 🙂

T-SQL is amazing.

ColdCoffee,

Hey look, this will work to show you how I want layout.

Select * from alldata;

It works because if you look at my revised DDL, you'll see the INSERT is...

Yes, unfortunately, I think my data has one more tier than your sample.

Also, unfortunately, the excel layout wasn't preserved when I used code="other" tags.

Well I came back to the forum to post the excel spreadsheet and see you've already got a solution. Wow.

OK, so here goes anyway. Here's what I'm after...

Can you give me tips on how to do here? It's very hard to simulate columns and rows with straight text. I have not had success inserting or...

Aha. I thought I'd covered that ground...but only with double quotes. Thanks.

I think I will answer my own last question. The answer is that usually a sproc would not be used to update multiple tables at one time, however if...

Thank you Dev.

Last question to tie things up for me. What brought me to his sproc was the question: 'how to insert data into multiple tables, using T-SQL'. ...

and now the sproc works too. That is too simply stuuppppiiiid (on my part, ofcourse :pinch:).

Dev, please, can you point me to a resource that will explain more...

I was wrong, Employees1 doesn't have an identity. Let me change it so it does and re-run statement.

Thanks so much. Here's the DDL.

USE [Northwind]

GO

/****** Object: Table [dbo].[Employees1] Script Date: 12/26/2011 23:23:03 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Employees1](

[EmployeeID] [int] NOT NULL,

[LastName] [nvarchar](20) NOT...

Dev,

When you re-org the query like that it is much more readable. Can we momentarily just focus on this insert query? The following query should insert into employees1 table...