this is a two step process. nothing wrong with that.

1) declare temp_table and insert the union into it

2) select from temp_table, grouping.

You should union the data first the group it. You are grouping first then union it.

I think you have complicated things, unless I'm missing some details.

You want to insert into your accumulative table from a source. Did you try

insert into accum_table (fields...)

select (fields1, fieldn) from...

to accomplish that you may need additional processing. now create a cursor based on that same query, sort by customer_id and accumulate in a variable all the different program_codes, once...

Read about:

SET TRANSACTION ISOLATION LEVEL    { READ UNCOMMITTED    | READ COMMITTED    | REPEATABLE READ    | SNAPSHOT    | SERIALIZABLE    }[ ; ]

and select the appropriate setting

1) Visual Studio 2005 Apps create a directory under current user's My Documents folder. OS standard. You have the option when creating the Project, in any VS App, to change...

Quick solution?. Create a new column in excel being the concatenation of underscore '_' and SSN column. After import run

update <table>

set <SSN_column_with_underscore> = replace(<SSN_column_with_underscore>,'_','')

You want to take this further, if you are documenting the DB?. Read the BOL for the sp_help. Then create a script to output the result set in the order...

Your best option is to find the 101 Tutorials. They even have that same sample, load pictures into a SLQ DB.

You will find much more than that.

Michael you are telling the kids you have candies, but they cannot have them?.

Come one, spit it out as next Question of the day. I'm sure you can replace it...

Ok, insert the SQL 2005 CD(orDVD) try to install but cancel after second screen, or after that file is created in the directory mentioned above.

I will keep searching for the...

read here: http://www.codeproject.com/database/MergeReplication.asp

Ah hah!!!, I know that dog. That probably means you have SQL2000 running side by side with SQL2005.

Run this C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe and uninstall each component at a...

read here http://www.windowsitpro.com/Article/ArticleID/14047/14047.html

here you go. notice that I created a table to capture what happened, to check if the trigger worked. I guess you may have your logic planned, like send an...