If we had ever met in person, you would not need to even ask 🙂

Well we have already met once in Boston, so I think it's only fair that for...

Another guess, just to pass the time:

SELECT

e.header1,

header2 = CASE WHEN GROUPING(e.header2) = 1 THEN 'Total' ELSE e.header2 END,

total...

I haven't responded because I don't know the answer. I was happy to answer the first question on this thread, but the new one is much harder to work...

DECLARE @A TABLE

(

TheDate date NOT NULL,

MIT integer...

Here's the sample code from your first post, together with a starting point for a solution:

Sample data:

DECLARE @Example TABLE

(

header1 char(6) NOT NULL,

...

Joe, I addressed most of your points with the code I posted, and comments made on other threads from this user. There is a learning process going on here;...

CREATE TABLE dbo.Test

(

PostID integer IDENTITY PRIMARY KEY

);

See also these topics in Books Online (The SQL Server Help Library):

Creating and Modifying Identifier Columns

SCOPE_IDENTITY (Transact-SQL)

That's a fair point. I did...

Explicitly defining...

This is why I mention them so much 😉

pCLR...

Sure:

DECLARE @parameter integer = 1;

-- Dynamic SQL

DECLARE @sql nvarchar(max) =

...

I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to convince me that I have no natural affinity...

Thanks! Though I...

Check...