I tried to do this a while ago and had no luch finding a way. sysuser does not contain such information and I found no table anywhere that would...

I would take a look at the executiuon plan in management studio and see what is happening. I suspect that for some reason Query 2 is doing a table...

It depends on your needs.

I assume you are new to SQL but the temp table is not a table at all. it is a variable that only exists in...

assuming you are doing this with an SSIS based on where the thread is posted. Then no you can not set it up to pick up header columns when...

declare a table variable and input the results into the table. then output the table variable.

Declare @tmptbl table columnname varchar(xx)

Insert into @tmptbl

select columnname from table1

Insert into @tmptbl

select columnname from...

I would think just add a step in your trigger to count the id's in T1 if the count is 0 then delete fro t2

Using the excel destination you can not control the format. you do not need Excel installed on teh destination however if you do happen to have it installed or...

move your Tempdb to the d: drive. there are several articles on-line on how to move you tempdb.

based on your sample data what you are looking for is way more complicated then simple grouping. Grouping would only group details that are alike in field 1. ...

when you say group on a variable can you give an example of what you mean?

not sure what happened but your results section does not display

I enjoyed the article and I also have enjoyed some of the comments.

I am fairly new to the SQL community and I have asked for help and responded...

Here is a script I use that you can get the concept from. It sends out a nicely formated html e-mail.

While I have made quite a few modifications to it...

just to throw my thought out there. We are currently running several DB boxes on VMWare with great success. VMware offers a few benefits I thought I would...

If you could post some table structures, sample data, and expected output that would help us