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

For the two date formats given the following will work:

-- set to european format.

SET DATEFORMAT dmy

DECLARE @t TABLE

(

CharDate char(10) NOT NULL

)

INSERT INTO @t

SELECT '31/12/2009' UNION ALL

SELECT '2009-06-30'

SELECT ISDATE(REPLACE(Chardate, '-', ''))...

With SQL2008 and the latest version of ADO you can even pass a table.

Without test data, and expected results, it is difficult to tell but maybe something like:

SET QUOTED_IDENTIFIER, ANSI_NULLS ON

GO

CREATE PROCEDURE dbo.P_SRE_T_CAL

@CURDATE datetime,

@ERROR varchar(50) OUTPUT,

@TRANIDUP varchar(8000)...