Something is very strange!

This post is duplicated 4 times, and cannot be deleted...

Something is very strange!

This post is duplicated 4 times, and cannot be deleted...

UPDATEa

SETa.x = CASE WHEN a.x b.x THEN b.x ELSE a.x END,

a.y = CASE WHEN a.y b.y THEN b.y ELSE a.y END

FROMTableA AS a

INNER JOINTableB AS b ON b.ID...

What you did was to calculate the CARTESIAN PRODUCT.

SELECT SUM(Items)

FROM (

SELECT COUNT(*) AS Items FROM TableA WHERE Col1 > '20090101' UNION ALL

SELECT COUNT(*) AS Items FROM TableB WHERE Col1 >...

No need to invoke SELECTs.

IF @user-id = 101 AND @Password = 'dgHH%Ggt4[' COLLATE SQL_Latin1_General_Cp1_CS_AS

PRINT 'Ok!'

ELSE

PRINT 'False'

But I doubt this is your real scenario. You do have a table where the...

DECLARE @mybin1 binary(8)

SET @mybin1 = 0x0000000000045F7C

PRINT CONVERT(varchar(8), @mybin1) + ' TEST'

SELECTmaster.sys.fn_varbintohexstr(@mybin1) + ' TEST'

Here is a 48-page long topic about a various attempts to write a good and decent split function

http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

I don't know what a split function is needed for here...

For concatenation, see this topic

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

In your CTE, ROW and VALUE elements are upper case, and in your cross apply the row and value path are lower case.

This results in an empty result. And I...

For your date range search, do not use all these filters

and ( ( ( leave.leave_start_dt between @start_date and @end_date)

and (leave.leave_end_dt between @start_date and @end_date) )

or leave.leave_start_dt >= @start_date and leave.leave_start_dt...

Also don't use table variables for this.

The minimum amount of data read by SQL Server is one page (8k).

As long as the amount of data is less than one page,...

Good effort but won't work.

1. XML is case sensitive.

2. Run the code again, after fixing the case sensitive elements, with this test data

insert into #temp values ('I like Ike &...

Well, the article is 7 years old, and does enforce some of the SQL Server myths.

TempDB is NOT locked when using temporary tables.

Why do you think there is a locking problem?

Using the SEQUENCE option in the XSD forces you to have the elements in same order in the XML file.

See http://www.w3schools.com/Schema/schema_complex_indicators.asp