You are admiting yourself that the newly...

"0-25", Thats what I think and thats what I answered. But didn't get the score...:-D

I agree with the solution of Andrew. BUT when I had this problem in my company, I was asked to return the exact Sum of time as TIME.

For example,...

Thats true, but what I pasted in my last post is from the...

20-25

Indicate system problems and are fatal errors, which means that the Database Engine task that is executing a statement or batch is no longer running. The task records information...

Select N from (Select Row_Number() Over (Order By a.Object_ID,a.Column_ID) N

from sys.columns a

Cross Join sys.columns b

Cross Join sys.columns c

) tblTally

where N Not in (Select Empid from tblEMP )

AND N...

I have witnessed many times that NOT IN works very slow in SQL Server 2005, especially when the it is comparing with a long list of string values.

Didn't knew...

Select N from (Select Row_Number() Over (Order By Object_ID,Column_ID) N from sys.columns) tblTally

where N Not in (Select EMPID from tblEMP )

AND N

between 1 and 15 -- Range

The concept is...

'-' sign used for the purpose of 'Except' in Database Engine Query window gives error...

if the Error message is:

The name ' SELECT x.SaleYear, x.TotalSales

FROM (SELECT SaleYear,

TotalSales= ISNULL((SELECT SUM(TotalSales) FROM InsSales

WHERE region= 'NE' AND SaleYear = y.SaleYear and salesPerson in ('Smith')

and SalesMonth <=...

Sorry, but ' Choose all that apply'...?

Try this function;

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- Select * From [dbo].[fnSplit] ('A,b' , ',')

ALTER FUNCTION [dbo].[fnSplit]

(@pString varchar(5000),@pSplitChar char(1))

returns @tblTemp table (tid int,value varchar(1000))

as

begin

declare @vStartPositionint

declare @vSplitPositionint

declare @vSplitValuevarchar(1000)

declare @vCounterint

set @vCounter=1

select @vStartPosition...

Any recommendation for the third party tool for this purpose?

I have checked BLOCKKK and SQL Shield in this regard. Any other option will be appriciated.

Copy the query in the query window and write the valid listID (against which data exists) replacing @listid and then execute it.

I am sure it will not give the...

GR8...