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...

I suspect SQL2005 does better syntax checking.

Your derived table, NOTA, only returns the columns SOMA and NUMDU. so

ORDER BY NOTA.CODLIQ DESC

does not make sense.

SQL2000 must try to find any column...

Your first query has the edrs_no filter in the wrong place.

Try:

SELECT uniqueid, course_code, instance_code, awarding_body, delegate_name,

course_title, glh, Employer_postcode, edrs_no, recordmanager, delegateid, entityid

FROM

(

SELECT uniqueid, course_code, instance_code, awarding_body, delegate_name,

course_title, glh, Employer_postcode, edrs_no,...

No, British English is either 'dd/mm/yyyy' or 'dd/mm/yy'.

Also, regardless of how the date is set, 'yyyymmdd' will always convert to a datetime.

So, for your...