As it was stated in the previous suggestion, you need to declare the namespaces.

DECLARE @x xml = '

<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">

<s:Schema id="RowsetSchema">

<s:ElementType name="row"...

Try:

SELECT

*

FROM

#employee

WHERE

Surname LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%'

OR GivenName LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%';

GO

I do not get the right result with the CHECKSUM suggestion. May be I am doing something wrong.

This is the result I am getting:

worker_id SNO

4 1

1 2

2...

I second Lynn regarding the needs to post DDL, sample data and expected result. Help us to be able to help you.

Regarding the problem / question I find it easier...

Try:

UPDATE customers

SET fee_history = STUFF(

(

select ',' + cast(F.id as varchar(10)) + cast(F.feetype as varchar(25))

from fees AS F

where F.custid = customers.custid

ORDER BY F.id

FOR XML PATH(''), TYPE

).value('.', 'nvarchar(MAX)'), 1, 1, '');

I hope...

Can you post the output from " print @DynamicPivotQuery "?

Use a ranking function.

with C1 as (

select *, row_number() over(partition by [year], [month] order by dt) as rnk

from calendar

-- exclude weekends and holidays

-- where isweekend = 0 and isholiday =...

Dwain,

The link to the article is broken. I am interested in reading it to find out why "specifically" it is faster than using LAG / LEAD.

One thing that is handy...

You could also use an offset window function like LAG or LEAD.

WITH C1 AS (

select *, LAG(SeqNo, 1, SeqNo) OVER(PARTITION BY RefID ORDER BY SeqNo, ID) AS prv_SeqNo

from [Sample]

)

SELECT *

FROM...

Try using NOT EXISTS instead NOT IN.

if exists(

select *

from Responses r

where not exists (

...

Try:

SET NOCOUNT ON;

USE tempdb;

GO

DECLARE @Xml TABLE (XmlData XML);

INSERT INTO @Xml

( XmlData

)

SELECT *

FROM OPENROWSET(BULK N'C:\Temp\test.txt', SINGLE_BLOB) O;

WITH XMLNAMESPACES (

'http://www.w3.org/TR/REC-html40' AS ss,

DEFAULT 'urn:schemas-microsoft-com:office:spreadsheet'

)

, C1 AS (

SELECT

N.x.value('(text())[1]', 'nvarchar(256)') AS val,

ROW_NUMBER() OVER(ORDER BY N.x)...

We have table-valued parameters since 2008 version.

http://technet.microsoft.com/en-us/library/bb510489(v=sql.105).aspx

I would suggest to start from here and just reach to other approaches if you are not able to leverage it.

You can check your other thread for the answer.

Here you have two possible solutions in case you are also interested in pulling the locale attribute.

DECLARE @XMLwithOpenXML TABLE

(

ID int identity,

XMLData XML,

LoadDatetime Datetime Default(getdate())

);

Insert into @XMLwithOpenXML(xmldata)

values ('<Internationalization>

<contentRecords locale="en_US">

...

Hope this helps.

Partitioned Table and Index Strategies Using SQL Server 2008

http://technet.microsoft.com/en-us/library/dd578580(v=SQL.100).aspx

I will also suggest all blog posts from Dan Guzman about this theme.

http://weblogs.sqlteam.com/dang/search.aspx?q=table%20partitioning