Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(NUMBERS) AS

( SELECT CONVERT(VARCHAR(7),X.NUMBERS,0)

FROM ( VALUES

('1.22345')

...

Head-desk

😎

scottlackey2001 (11/3/2016)

---

is there a way to loop through rows without using a cursor? I can select my rows into a temp table and all, but need to loop through...

scottlackey2001 (11/3/2016)

---

I've got a DECLARE CURSOR and I wish to loop through and process rows that meet certain criteria. I want to use a WHILE loop to process such...

User7766 (11/3/2016)

---

Added this line to make it work, somewhere i'm missing the casting

,MessageBody = CAST(MSG.DATA.query('(.)') AS nvarchar(MAX))

Thanks...

Here is a suggestion, should be enough to get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Employee') IS NOT NULL DROP TABLE #Employee;

Create table #Employee

(

ID int identity (1,1) ,

FirstName...

User7766 (11/3/2016)

---

Hi,

Thanks for the query!

I'm able to select all the columns from XML, But when i try to run the insert query getting below error.

Implicit conversion from data type xml...

DesNorton (11/3/2016)

---

Shredding xml is not exactly the best perfprming operation in SQL. Rather get the UI to shred the XML and pass you a TVP (table valued parameter).

If you...

The XML data type in SQL Server can easily handle multiple root nodes which is somewhat an exception to the rule, my concern was that normally this would break or...

This XML is not well formed as there are multiple root nodes, is this the actual XML?

😎

The CTE in your code will only retrieve values from the Header part of...

matej_grabnar (11/2/2016)

---

After upgrading from Windows 7 to Windows 10 - and after some updates of windows a very slow connection (10 - 20s) to SQL server accrued.

Queries are executing...

You are very welcome.

😎

Locating a string pattern within a string is straight forward, regardless of whether the string is an XML or not, here is a quick example of a search in an...

In most cases, we will see up to 2 times better performance when applying this method, more commonly the difference is greater. Here is an example, results speak for themselves...

spidey73 (11/1/2016)

---

It must have something to do with authentication/privileges on the Server A on which the SSIS package is hosted and executed by a SQL job.

Because when I elevate the...