Example? Test Data?

a

greed

What can I buy with my points?

Do you always need a unique value or just for certain situations? Short term you could possibly use a temp table in lieu of the view. Or how...

SELECT empname

FROM edtl

GROUP BY empname, sal

HAVING sal < (SELECT AVG(sal) FROM edtl)

Dude (Jeff), you are so smart!!

#Report has 145 records

TableA has:

- 10,254,648 records

- a clustered index on WorkOrders_ID

- a nonclustered index on ServiceEvents_Code

TableB has:

- 2,099,655 records

- a clustered index on ID

- a nonclustered index on ReturnDate

I...

What do you mean by xp'x and @@severname?  I thought you were looking for data types of specific columns.  What is "docs?"  ????

Just turn this into a sproc, and use in the desired DB.  This will work in Northwind

USE Northwind

GO

DECLARE  @Table varchar(35),

              @Column varchar(35)

SELECT   @Table  = 'Employees',

             @Column = 'EmployeeID'

SELECT   type_name(st.xtype)

FROM     systypes st

JOIN       syscolumns...

Do you use "count(x)"?

12/02/2007 would never (without more) appear first when using TOP, regardless of the sort order.

Sam,

Here is a very basic example using an optional paramater.  The parameter @title is given a default value so users do not have to pass in a value unless they...

Thank you both!!!

Thanks Jason.  That's so smart!