See if this helps

DECLARE @x XML

SET @x=NULL

SELECT @x.exist('/*')

SET @x=''

SELECT @x.exist('/*')

SET @x='<Root/>'

SELECT @x.exist('/*')

If you mean this

SELECT NCHAR(8486)

you'll need to use an NVARCHAR or NCHAR column

Here's another way

WITH CTE AS (

SELECT Name,Date,Trend,Strength,

ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Date) -

ROW_NUMBER() OVER(PARTITION BY Name,Trend,Strength ORDER BY Date) AS rnDiff

FROM @tbl)

SELECT Name,MIN(Date) AS Date,Trend,Strength

FROM CTE

GROUP BY...

Not entirely sure if it's a bug or not, but I think it's to do with the expansion of [A-Z]. If you change it to [ABCDEFGHIJKLMNOPQRSTUVWXYZ] it works correctly.

Jeff Moden (7/18/2011)

It's just me, I know, but I name my tables after what a single row of any given table contains. Part of the...

Have a look here

http://databases.aspfaq.com/database/what-naming-convention-should-i-use-in-my-database.html

and just for fun...

http://www.thc.org/root/phun/unmaintain.html

SELECT Place_ID,

SUM(CASE WHEN ReceivedDate - GETDATE() >'1899-12-31' THEN 1 ELSE 0 END) AS 'AllAvai',

SUM(CASE WHEN ReceivedDate...

SELECT DISTINCT a.Cust

FROM dbo.TT a

WHERE NOT EXISTS (SELECT * FROM dbo.TT b WHERE b.Cust=a.Cust AND b.Item=15)

ORDER BY a.Cust;

ORDER BY CASE WHEN CITYNAME='Bangalore' THEN 0 ELSE 1 END,CITYNAME

DECLARE @xml_result XML;

WITH XMLNAMESPACES('http://www.w3.org/2001/XMLSchema-instance' AS xsi,

'http://www.w3.org/2001/XMLSchema' AS xsd,

'ns0:cape_site' AS ns1),

OrderedData AS (

SELECT jc.WBSNumber,

jst.EquipmentNo,

SUM(jst.Qty) as Qty,

ROW_NUMBER() OVER(PARTITION BY jc.WBSNumber ORDER BY jst.EquipmentNo) AS rn

FROM...

Something like this?

DECLARE @T TABLE(Asset CHAR(1),PeriodYear INT)

INSERT INTO @T(Asset,PeriodYear)

SELECT 'A',2009 UNION ALL

SELECT 'A',2009 UNION ALL

SELECT 'B',2010 UNION ALL

SELECT 'C',2009 UNION ALL

SELECT 'C',2010 UNION ALL

SELECT 'C',2010;

SELECT Asset,

...

Second attempt, sort of 'relational division', should be quicker than the first

WITH Employees(Employee,ModeOfTransport) AS (

SELECT 'Employee1' , 'Car'

UNION ALL

SELECT 'Employee1', 'Bus'

UNION ALL

SELECT 'Employee1', 'Train'

UNION ALL

SELECT 'Employee2', 'Car'

UNION ALL

SELECT 'Employee2',...

Yep, I suspect there's a fast way to do this without having to group by a concatenated string. Can't...

Try this

WITH Employees(Employee,ModeOfTransport) AS (

SELECT 'Employee1' , 'Car'

UNION ALL

SELECT 'Employee1', 'Bus'

UNION ALL

SELECT 'Employee1', 'Train'

UNION ALL

SELECT 'Employee2', 'Car'

UNION ALL

SELECT 'Employee2', 'Bus'

UNION ALL

SELECT 'Employee3', 'Train'

UNION ALL

SELECT 'Employee4', 'Car'

UNION ALL

SELECT 'Employee4', 'Bus'

UNION ALL

SELECT...

As far as I know, the only workaround is to convert the XML to the varchar(max) type and then prepend the header

SELECT '<?xml version="1.0" encoding="ISO-8859-1" ?>'

+

CAST( (SELECT ... FOR...