Ok, why am I getting a syntax error near the = sign in the where clause on
this. BTW, all tables listed are in the from clause:
where case when reference_type='service' then
order.order_num=orditem.order_num

Is there a way to display a table definition (something like sp_help)
but only with column_name, type and length?  I'd like to be able to see
all three columns in one screen, whereas sp_help makes you scroll to the
right to see them all.  Thanks.

RE: Quarterly report - calculating for each of next four months?
As I play with joins and functions to help mold my data.. I'm
thinking
about options.

declare @text    nvarchar(max),
    @spid    int
select @spid = 178
select @text = text

Using sql 2000
I have a Stored Procedure that has very big queries joining on different
Databases.
When using

I'm running the query 'select * from table' in Query Analyzer, and when I
execute 'sp_who' it shows that it's blocking itself.  How do I troubleshoot
this?

I'm sure there's a simple solution for this. Essentially, I want to query a
table for a specific combination of data and return a single row back if the
condition is met. Other than using views or subqueries, I'm not seeing it.
Example:

i've been using SQL Server for ten years. A few months ago i thought i
finally ran into a case where i needed the constraint behaviour of SQL
Server. i turned to my colleagues and said,  "You'll never believe it. i
actually have case where SQL Sever's handling of a unique ...

Is there a way to terminate a given Transaction ID without using KILL
<spid>?
Given the situation where a SELECT query on one thread is taking an
inordinate amount of time to complete, I would like a second thread to be

I want to write a t-sql statement to insert record new records as long as the non-blank record count is < 50.  Once it hits 50, I want to send a message to the user saying the sorry, we have reached our limit.  Note, I want to count records that have data in it, if a record has ...

OK, I've copied a large number of Oracle tables to SQL Server using
DTS.
Is there any way I can do this using a command-line interface (perhaps
one table at a time)?  The point is to be able to do this as easily as

I have 5 different tables where I might be able to put columns for an
address: ArrivalLocation, DepartureLocation, Host, Hotel and Venue. I was
wondering if it would be better to add the address columns to each of these
tables or create a lookup table with those table names as ...

I have a query in the stored procedure which has a parameter
@FirstName varchar(39). The query looks like this:
SELECT B.CustomerNo  FROM Customers A JOIN Customers B
ON A.CustomerNo <> B.CustomerNo

Hi All, I'm a noob to SQL and am trying to run a query that goes a
little something like this.
DECLARE @StartTime DATETIME
DECLARE @EndTime DATETIME

create table demo(id int)
go
insert into demo
select 10 union all