BKW - have you thought of creating a dynamic T-SQL statement such as

CREATE PROCEDURE Dbo.GetIT

@TableName VARCHAR(5)

AS

DECLARE @sql VARCHAR(50)

SET @sql = 'SELECT * FROM ' + @TableName +...

Use SSMS, navigate to the database, expand the database, right click on the table you wish to script, then select "Script table as", select "Create", then select one of these...

Serigy

That is putting the frosting on the cake, or the cherry on top of the ice cream Sunday. Hope the OP does what you suggest and gets all the...

Paul Mc

A very similar question was asked in another forum and here is the most flexible approach given as the answer. This may also be the answer to your...

From Access help files

You can use the ListIndex property to determine which item is selected in a list box or combo box.

Setting

The ListIndex property is an integer from 0 to...

Try this as your select statement

SELECT claimid, Max(revcode) AS 'RevCode'

FROM #myHead

GROUP...

Hopefully you would have a test database, even something as simple as the free express version.... then you could try your T-SQL code and answer your own question.

Read these from...

Paul_J

A very similar question was asked in another forum and here is the most flexible approach given as the answer. This may also be the answer to your question....

Read this article by Jeff Moden it will teach you how to do what you want.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

By Jeff Moden, 2008/08/19

http://www.sqlservercentral.com/articles/T-SQL/63681/

If your Excel files are available in CSV format (in which an Excel file consisting of a single work sheet can be saved) then look at this forum posting (made...

Is it possible for you to use an INSERT INTO statement? From BOL:

The SELECT INTO statement creates a new table and populates it with the result set of the...

If you are using Excel 2007 be advised that some important old limitations have been removed:

The total number of available columns in Excel

Old Limit: 256 (2^8)

New Limit: 16k ...

Why would you want users to have access to both databases?...

Clas -- I see a lot of data but NO QUESTION [/B]. Also your date value does not appear to be relevant.

This is identical to the posting by the same individual to SQL Server 2005 Security.

Ooops Jack you sure can type faster than I can ...