I have a Stored Proc and would like to pass in a VARCHAR parameter. The
problem is that the query will need to use it in a IN clause...
DECLARE @PARAM AS VARCHAR(20)
SET @PARAM = 'Dan', 'Mike', 'Lisa'

I would appreciate it if someone could help me on the following:
I have several tables eg, tbl1, tbl2, tbl3.....tbl10. How to view all the
tables structure
and indexes using SQL Query Analyzer or using stored procedures.

I want to be able to check if column 27 has been updated either on an insert
or an update.
If this column has been updated with a value I want to insert the following
fields into a different table (InvMov) within the database:

I can't seem to figure out how to create a cross tab or pivot query on data.  
If I was writing the SQL in Access I would write it like
TRANSFORM SUM(DTL.Amount) AS Amount
SELECT

I want to be able to check if column 27 has been updated either on an insert
or an update.
If this column has been updated with a value I want to insert the following
fields into a different table (InvMov) within the database:

I have 2 tables, Make and Model where Make is the master table and Model has
a reference of make table by Make_Id since there can be multiple models for a
single make. Now, i have 4 SQL's below and i want to know which SQL should
perform better.

hi
i am facing one  problem
i am having two table location and routesegment
location table having locationid as primary key.

I have SQL Server Developer edition on my laptop.  Want to install MSDE on
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?

i have to translate SQL-Statements from Access 2000 to SQL
Server 2000. There was a lot of Access-Functions used
(mid, str, iif ...) and i convert them to SQL-Server
Syntax, but i dont found a way to simulate the results of

I have two of the exact same rows, but I want to change one field of one of
the rows.  How do I do this?
i.e.
table_a

What is the syntax for a query that will give me the Count of [PartID]
shipped each month. I think I need to do a Count on PK_ID and Group By the
DateShipped but how do I format the date. I tried using DateName but I can
only get it to work if I split out the Year and month. ...

Hi
I am using Mssql2000 and i am facing a problem while saving data from my
application.
This Procedure is working fine.

Hi every one
I am having problem with search, I have data in sql server in arabic
language , when I am searching via submitting a form using asp it returns me
nothing and select statment looks like this "Select * From arabic Where

My order dates of service load from a text file and contain "today minus 1,
plus 3".  For example, using today's file, this equates to yesterday's date
(4/11) through Friday's date (4/15).  What I want to delete using a SQL
command daily that requires no input from me is ...

hi
I have problem with sql. I dont userstand what should I do.
my problem is
I have table UserLocationHistory