You could put the whole query into another query:

select 'SSA Location', 'OptiPlex GX240', ... , 'OptiPlex GX240'+... as SSATotal

from (

SELECT DISTINCT

s.Location00 AS 'SSA Location',

SUM(CASE c.Model0

...

from http://www.devx.com/tips/Tip/17053

with more detail at: http://www.databasejournal.com/features/mssql/article.php/1459181

Running a DTS Package Through TSQL with a COM Concept

What if you wanted to use a COM object through TSQL Statement? SQL Server facilitates this...

well, you install it.

SQL Server installs at least 3 tools to let you work with the database.

First, the stand-by command-line tool, osql.

Next, the graphical equivalent (but it's WAYYYY better than...

Try to recompile the package in Oracle. If you're using a tool like TOAD, you can easily see the compile state of the package. Then, look inside the package to...

A bug with Access 2000 (and maybe 2002, but fixed in 2003) with linked SQL Server tables might cause a table that you've linked to, when you change data, to...

Yep. All of the expressions not used in aggregate functions need to be in the group by clause.

Hmm...

you could store it as an integer also:

cast(someintfield as smalldatetime)

ex:

select 1, cast(1 as smalldatetime)

1 1900-01-02 00:00:00

You can format the time part away for a datetime or smalldatetime...

DTSRunUI isn't redistributable, but of course, DTSRun is. You could script DTSRun in a VBScript.

It is also possible to add a couple of stored procedures to the database to run...

I'm almost sure that ColdFusion is using ODBC to communicate with SQL Server, and ODBC mangles the SQL you might pass into it into its own version of SQL before...

Maybe .Net 1.0 will work on Win95, but I'm pretty sure that .Net 1.1 won't.

You must have a compelling need to do this on Win95.

Can you upgrade the system to...

Hmm... there are the NLSSORT and NLS_SORT functions to try as well...

As far as case-insentive searches and indexes... unless you're hitting a desktop database like Access, you probably can code...

assuming you're trying to run the script on your computer, the simplest way is from the command line:

C:\>osql -E -d mydatabase -i mysqlfile.sql

...of course, this implies that

C:\program...

Are you sure you want to do a join? It almost looks like you want to do a UNION query, i.e.,

select id, column1, '1' as tblid

from table1

union all

select id,...