SQL Server 2005.
I have a view defined for a database.  Part of the query is:
SELECT dbo.GL7PROJECTS.PROJECTID AS JURISDICTION
I have not problem using JURISDICTION in the ORDER BY clause, but when I try

SQL Server 2005.
I want to do a query that will accomplish both a LIKE type search and an IN
type search.  I have a variable number of LIKE strings that I want to search
on.  I know I can say:

I am using a database with n tables in it. I have a set of field names with
me. what I want is to find the names of the tables in which a particular
field is mapped to or related to in order to find the effect of a particular
field to the database.

i have a table that has some informatio regarding an office building in it.
It also has the building managers information in it.  I want to create two
new tables.  One with just the building info, and one with just the managers
info.  Now, I have created the two new tables.  In ...

As a background:
1) I am using SQL 2005
2) Reporting Services.
In order to achieve certain report requirements I have created 2 VIEWS on

Declare  @a char(7)
if the lenght of the inserted value in @a is less than 7. the zero's should
be added on the left side to make it of lenght 7.
set @a = aaaa