Trick question as there was no trick in the question:-D

Thanks Andy!

😎

Congratulations!

😎

For fun:-D, here is a full shredding code

😎

DECLARE @XORDER XML = N'<?xml version="1.0" encoding="utf-16"?>

<order>

<Product Index="e1e2c499-f9...etc...." ProductID="12">

<Attribute Name="Paper...etc..." />

<Attribute Name="Ink..etc.." />

...

If the data sample is accurate, this can be simplified by using XML and XQuery

😎

DECLARE @String nvarchar(500) = N''

SET @String = N'

Assessed By: Michael Jordan Yagnesh

Reviewed By: Fred Smith

Home Address'

DECLARE...

Now we have the full question, here is the answer.:-D

Your query is missing the FROM part.

😎

--my table payment_details structure is

DECLARE @payment_details TABLE

(

payment_id ...

neethu payal (6/21/2014)

---

my table structure is

payment_id payment_code

1 null

2 ...

pk2dpvp (6/19/2014)

---

Anyone has any suggestions? ^^

I found loads of things but nothing seems to work...

I'm trying to get a link with XML data inside the page into a table but...

brad.mason5 (6/20/2014)

---

One thing I have noticed recently is TSQL is not the best tool to use when it comes to XML. C# is far more efficient at searching and...

Here is a quick solution using a CALENDAR CTE

😎

USE tempdb;

GO

;WITH SampleData (PERSON,[HOURS],[RATE],[CODEID],[DOW],[DATE]) AS

(

SELECT 1234,7.00,40.00,01,'Thursday','05/01/2014'

UNION ALL SELECT 1234,8.0,40.0,01,'Friday','05/02/2014'

UNION ALL...

N_Muller (6/20/2014)

---

I have an XML file about 25MB. When I read it with openrowset it gives me 'System.OutOfMemoryException'. The machine I'm running has 16GB of RAM and memory is...

ykonline (6/20/2014)

---

Hi,

I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary.

Suppose, the...

Take a look at this article, How to Return Running Product Totals.

I think the method I used earlier has already been posted on this thread, it is the same as...

Bear with me here but is this the result you are after?

😎

MyLongDesiredRunningTotalSequenceWK NOACCOMPUSD_AMOUNTSOA_TYPE

100.00191620112003100.00Agent

300.002101620412003200.00Freight

450.003111620712003150.00Agent

700.005121620812003250.00Costs

1100.006131622412003400.00Cost

1600.007141629512003500.00Freight

2140.008151629512003540.00Cost

pwalter83 (6/20/2014)

---

Hi,

I am trying to calculate running total in sql as its not giving me the desired result on SSRS (on the fly calculation).

I tried using the following code but...

AndrewSQLDBA (6/19/2014)

---

Hello Everyone

I hope that you are having a very nice day. To some, it is already friday, the weekend is closer for you.

I am selecting data from a View...