The First /2.0 is a computed FORMULA for the median so it has to be DECIMAL or FLOAT

The Second is just a count of RECORDS(ROWS)!! so it can't be a...

It looks that we are in synch today

FROM BOL:

This is the precedence order for the Microsoft® SQL Server™ 2000 data types:

• sql_variant (highest)
• datetime
• smalldatetime
• float
• real
• decimal
• money
• smallmoney
• bigint
• int
• smallint
• tinyint
• bit
• ntext
• text
• image
• timestamp
• uniqueidentifier
• nvarchar
• nchar
• varchar
• char
• varbinary
• binary (lowest)

from the Precence list your datatypes "if can be converted...

Try:

SELECT T.vruconfirmation,T.jobtype,T.jobid

 FROM ttt T

JOIN(

 SELECT  jobid, Count(*)as Cnt

 FROM ttt

 GROUP BY jobid) Q ON  Q.jobid = T.JOBID

WHERE Cnt = 1 OR (Cnt > 1 and vruconfirmation IS NOT NULL)

ORDER BY T.jobid

It Depends  if it is a DTS package that has the USE TRANSACTIONS and COMMIT ON SUCCESFUL PACKAGE COMPLETION  (Package Properties --> Advanced Options) it will...

you want to check this

Sorry for the Bad news but this is HOW MS want you to fix it

mssql_rules,

I think COST is the Key word here. The fact that you have HIGER Query cost does NOT means you have HIGHER IO!! set the STATISTICS IO ON and re-run your...

Because you are trying to query a remote SQL server I would rewrite that code as:

SELECT a.Cnt

FROM OPENROWSET('SQLOLEDB','Apollo';'sa';'',

   'SELECT COUNT(*) as Cnt FROM pubs.dbo.titles ORDER BY au_lname, au_fname') AS a

OR

Create...

If the Update RATE is not TOO high (That means Test, Test and Test)

I would calculate at Update / Insert Time and save results on a DENORMALIZED Field!

so when you...

Take a look at Partitioned VIEWS on BOL

This is my LAST time anwering questions that have been POORLY/INCORRECTLY Posted!

FROM BOL:

MOVE 'logical_file_name' TO 'operating_system_file_name'

Specifies that the given logical_file_name should be...

why do you have to use IN?

SELECT *

FROM TableName

WHERE Id1 = @ID1 AND ID2 = @ID2

if you open QA and DRAG & DROP the Colums Folder into the Editor the Field List gets created for you. It doesn't get better than that

OR

select column1,column2,3,4,n

from Survey1

UNION ALL

select column1,column2,3,4,n

from Survey2

UNION ALL

select column1,column2,3,4,n

from Survey3