Jason, might I suggest that you look at EXCEL's help file. In particular the subject Automatically numbering rows. An extract of what can be done is:

Select the first...

The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way.

You might want to read this:

http://www.sqlservercentral.com/articles/Development/2734/

A partial extract from the above article.

PIVOT FUNCTION:

It widens...

The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way.

You might want to read this:

http://www.sqlservercentral.com/articles/Development/2734/

A partial extract from the above article.

PIVOT FUNCTION:

It widens...

You could use the CONVERT function for example:

DECLARE @Num4 AS DECIMAL(10,4)

DECLARE @Num2 AS DECIMAL(10,2)

SET @Num4 = 1234.9876 ...

Hanshi and Cy

A technique I have used in SQL 2000 to determine which tables are used or not used is contained in Forum posting

http://www.sqlservercentral.com/Forums/Topic562824-145-1.aspx#bm564071

I will be fair and honest, if...

Declarative Referential Integrity (DRI)

From:

http://www.cvalde.net/document/declaRefIntegVsTrig.htm

This is a metadata declaration that enforces a dependency relationship between two tables through one or more fields. So, the engine itself is in charge of verifying...

Randy -- Application roles are not assigned to users -- for a rather lengthy, but valuable discussion of how to use Application Roles and how users access these roles please...

Has Sergiy properly understood your question? If so then ignore what follows.

Your data for item 2 is:

CustomerID TestID

2 ...

Arthur.Lorenzini

I have duplicated what I can deduce as your Customer and Customer_Income tables, using both SmallMoney and Money as the data type for your gross_income column. I...

. Isn't this a...

To expand beyond the simple parsing of Last name, first name to what you have asked may I recommend reading an excellent article by Steve Jones at http://www.sqlservercentral.com/articles/Advanced+Querying/20010422115807/91/

Also consider Steve's...

Had a project using Windows 2000 which was using an ACCESS DB rather than SQL server, performing much the same task as you have outlined. One problem was discovered...

Jeff: I am taking it...

If you wish to do this programmatically then use ADOX. This Microsoft site presents the ADOX object model, with links to just about everything else concerning ADOX. By...

Original answer to you was faulty so I removed same. Sorry about that.