I suspect using CASE would work better:

DECLARE @StartDate datetime

,@EndDate datetime

SELECT @StartDate = '20090920'

,@EndDate = '20090923'

SELECT [Terminal ID]

,COUNT([Terminal ID]) AS TotalTrans

,COUNT(CASE WHEN Reject = '' AND [Fee Amount] <> '0000000' AND...

In SQL2008 this blog from Hugo Kornelis suggests that using MERGE is the way to go:

http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspx

If you have a lot of columns to compare then you can use INTERSECT as...

EXEC sp_executesql ...

Syntax is in BOL.

Brian Cromwell (9/3/2009)

---

I am having a performance issue with a query that contains UNION ALL. If I run the queries separately (view vwA and vwB, for example), then their...

Just use the REPLACE command as suggested above. Something like:

SELECT REPLACE(REPLACE(REPLACE(REPLACE(@SearchText, ' and ', '_AND_'), ' or ', '_OR_'), ' ', ' OR '), '_', ' ')

Calling a SP from within a trigger is usually a bad idea. It also suggests that you are using a cursor within the trigger - an even worse idea.

I suspect...

DECLARE @jdate int

SET @jdate = 109252

SELECT DATEADD(d, @jdate - 69189, 0)

UPDATE needs to know which columns it is updating so the only way with static SQL is:

UPDATE RB_Products

SET Sequence1 =

CASE @TypeId

WHEN 1 THEN @sequence

ELSE Sequence1

END

,Sequence2 =

CASE @TypeId

WHEN 2 THEN...

Even to SQL2008, SCOPE_IDENTITY() etc still have a parallelism bug.

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/03/21/six-reasons-you-should-be-nervous-about-parallelism.aspx

I am not sure what you are attempting but

SELECT IDENT_CURRENT('table')

will return the last identity value generated for a given table.

If the last insert was rolled back, this will not be...

DECLARE @t TABLE (t bit)

DECLARE @r int

SET ROWCOUNT 100

INSERT INTO @t SELECT 1 FROM YourTable WHERE [name] LIKE 'a%'

SET @r = @@ROWCOUNT

SET ROWCOUNT 0

PRINT @r

Umm... not according to my understanding.

DECLARE @t TABLE

(

Col int

)

INSERT INTO @t

SELECT NULL UNION ALL

SELECT 1 UNION ALL

SELECT NULL UNION ALL

SELECT NULL UNION ALL

SELECT NULL

SELECT COUNT(Col)

FROM...

I think Dave is a bit cross-eyed this morning! 🙂

The OP is JOINing on ClientID but COUNTing BackupID. This could...

Logically the main clauses of a SELECT statement are evaluated in the following order:

FROM

WHERE

GROUP BY

HAVING

SELECT

DISTINCT

ORDER BY

ie WHERE is evaluated before Total is defined so the only way to use it...

river (8/14/2009)

---

ok, thank you very mutch.

I have other question related to the same problem.

I now can run the query, but in SQL Server 2000 this query executes in 2...