SELECT     TOP 8

           JobPK,

           JobTitle,

           Location,

           JobDescription,

           dbo.udf_PAY_FORMAT('£', SalaryMin, SalaryMax, SalaryFrame, SalaryDesc) as Salary,

           j.HideContactDetails,

Something like this, maybe?

-- Prepare sample data

DECLARE     @Sample TABLE (Patient SYSNAME, ServiceName SYSNAME, ServiceLevel INT, StartDate DATETIME, EndDate DATETIME)

 

SET DATEFORMAT...

It depends.

We can guess, but showing your table's DDL will help us much.

SELECT *

FROM Table1

INNER JOIN Table2 ON Table2.Col1 = Table1.Col2

WHERE SCOPE_IDENTITY() = 99

As you can see, queries can look...

Can you post some proper expected output base on the sample data above?

 

SELECT

au_id,

au_lname

,

au_fname

,

phone

,

address,

city

,

state,

zip

The IN clause is 16000 characters?

May I ask if you also have some performance problems?

 

SELECT TOP 2000 *

FROM Table1

WHERE ID >= 30000

ORDER BY ID

 

 

SQL Server 2005 offers a better approach!

ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }ON { object_name | DATABASE | ALL SERVER } [ ;...

SELECT *

FROM DateTableFunction() AS dtf

LEFT JOIN BookingTable AS bt ON bt.FromDate < dtf.Date AND bt.ToDate > dtf.Date

WHERE bt.FromDate IS NULL

Also, a more efficient date tabelfunction is found here

http://www.sqlservercentral.com/columnists/plarsson/howmanymoremondaysuntiliretire.asp

 

ROW_NUMBER() will give a unique number within the partition regardless of order by.

DENSE_RANK() will give a "rownumber" depending on order by.

If column used in order by has multiple values, all...

Sorry, but what is your question?

 

He is all over the places so this must be reallt important, having twice the number of helpers...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88706

I suggested adding a ";" before the WITH keyword