Hi

Sorry about the late post, but parallel is always a tricky one. First decision to make is which side of the line do you want to parallel to? ...

Luis Cazares (4/3/2014)

---

I always forget to use the nested replace solutions. It should outperform the splitter.

I wish that SQL Server could include a "pattern replace" to get something like

SELECT...

Hi

If the OP requirements are as simple as remove all digits from the string, I would tend to just use a nested replace within a LTRIM to tidy up the...

I looked at the topic and thought wahoo they've do some enhancements to spatial ... but of course the spatial stuff hasn't changed in 2014:( Made me look though:-)

lmnorms (4/2/2014)

---

Ok. One last question: I need to get the line '<?xml version="1.0"?>' in the top of the results before any xml. How can I do that using the statement...

Hi

Because I've had to study up on this lately:w00t:, you could also try

SELECT EmployeeID AS 'Employeeid',

CellPhone AS 'mobile_Phone/Number'

FROM Db_Utils.dbo.tb_tst_Employees_upd p

WHERE p.EmployeeID IN ('000001', '019999')

FOR XML Path('Row'), ROOT('Employee_List');

sqlservercentral 18091 (4/1/2014)

---

Thank you again for your help... though as yet, I am trying to understand what you have done so that I can better apply to my situation.

I have...

Hi

I'm not sure that I have your requirements right, but this may help you with your problem. Basically I am unpivoting your data so I can reorder the tyres...

Hi

I am failing to see why you would need to do a sum of a sum. Surely only a single sum is required?

As an example, the two following queries...

Hi

I don't think the result you have posted can result from the data you have posted. Also have a read of this article[/url] to assist with getting the best...

+1, I have really enjoyed these questions as well.

triynko22 (3/19/2014)

---

mickyT: Which query do you think is a "winner", because those are not logically equivalent queries to my original query. For example, query 6 is using an "exists"...

Hi

As pietlinden asked is there a key to group the data rows. Looking at the sample data you provided, I'm guessing that it is the MSGID column. If...

The plans are actual.

And here is Paul's blog that Gail referred to.

Hi

Have added the various query options now and we have a new winner 😀 with a query that makes sense-- Statement 1

SELECT COUNT(*)

FROM Table1 c

WHERE NOT EXISTS ( SELECT...