I understand that the names of the database objects are in lower case and you want to have them in upper case?

Although I have posted a solution below, there is...

As "Phil Factor" indicated "The database hasn't been normalised" but additionally the search criteria is also an array and arrays cannot be easily manipulated with SQL.

The solution is to create...

The command line was truncated:

isqlw.exe -S SqlServerName -D DatabaseName

You can also create a shortcut to Query Analyzer that will automatically connect to a specific server and database. The command line is:

isqlw.exe -S

You can also add...

Assumming that a nested loop will be used and HISTORY...

"How does this work for connecting to named instances?" DNS aliases work for the server name and not for named instances.

That is why I recommend only one instance per...

A new category should be security:

Only grant the minimum privileges necessary including:

Only DBAs should have any server level roles.

In development, grant minimum rights (ddl_admin is the highest privilege) and do...

For Winning Percentage, which is not a percentage but is a rate but...

As Games Behind is within Division within League, here is a solution. Note that Winning Percentage is defined as a computed column.

Create table TeamRecord

(Leaguevarchar(255)not null

,Dvarchar(255) not null

,TAvarchar(255) not null

,Wtinyintnot...

Without the create table statements, it is not clear how this should be solved, but here is one possibility:

SELECTtblClientImport.StmtNum

,tblStatements.Stmt

,tblStatements.Count_Range

,tblStmtChar.CharNum

,tblCharacteristics.Characteristic

FROMtblClientImport

INNER JOIN tblStatements

ON tblClientImport.StmtNum = tblStatements.StmtNum

LEFT OUTER JOIN

tblStmtChar

on tblStmtChar.SurveyNum = tblClientImport.SurveyNum

and tblStatements.Count_Range...

For a solution, please read "How do I create a cross-tab (or "pivot") query?"

at http://sqlserver2000.databases.aspfaq.com/how-do-i-create-a-cross-tab-or-pivot-query.html

"stores a time duration as a varchar eg. 00:01:06"

The problem is the physical datatype used and the that formating is stored. More appropriate would be a numeric datatype such...

Please see "How do I use a variable in an ORDER BY clause?" at

http://databases.aspfaq.com/database/how-do-i-use-a-variable-in-an-order-by-clause.html

"But put in DISTINCT and it stops working" - actually it gives an error "Server: Msg 145, Level 15, State 1, Line 4

ORDER BY items must appear in the...

This appears to be a variation on First-In First-Out allocation such as for allocating Payments to Invoices or for "best fit"

Someone posted a SQL solution this month but I cannot...