Yes and No - I already had to use a SQL Server to perform HTTP POST commands

as a result of lack of knowledge of customer's .Net team and it works...

Thanks for your reply - it was the first thing I have asked as well.

An issue is that I am not allowed to bring any 3rd party tool as of...

Will it work for you?

DECLARE @a INT;

DECLARE @my_sql VARCHAR(MAX);

SELECT @a = MAX(LEN(Id)) FROM Account;

SET @my_sql = 'SELECT CONVERT(VARCHAR('+CAST(@a AS VARCHAR(10))+'), Id) FROM Account';

EXEC (@my_sql);

Actually it seems that I am wrong - Like should be faster than CHARINDEX:

--Quote -----

LIKE and CHARINDEX are created with two different purposes.

LIKE can use an index if...

Same as above, but might be a bit faster:

select a.*

from a

join b

on CHARINDEX(a.field_1, b.field_2) >0

Oh boy.....:blush:

Mark,

now to the most stupid question, please:

How do I assign the result to a variable, i.e. how do I write something like this that will also work 😀

DECLARE @xml_result xml;

@xml_result...

This is what I thought as well, but didn't want to convert it to VARCHAR.

Again, thanks for the help.

OK,

First you won - yours looks better 😀 . Thx

Second - I was too excited: How do I add <?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>

for the happy end?

THX!

SOLVED IT!

THANKS FOR THE IDEAS!

DECLARE @xml_body xml;

SET @xml_body = (

SELECT jst.EquipmentNo "erected_equipment_list/equipment_code",

SUM(jst.Qty) "erected_equipment_list/erected_qnty"

FROM Job_Stock_Tbl jst

JOIN...

Thanks

Let's omit XMLNAMESPACES for a moment,

How would you update my code to extract the site_code element only once, please?

Thanks

Apologies,

please find below:

CREATE TABLE Job_Stock_Tbl

(

CapeId INT NULL,

EquipmentNo VARCHAR(15) NULL,

Qty ...

Then I will take a look in your steps.

Thanks

Hi Siva,

Not sure I have understood your answer - I know how to do it in Oracle (to be honest, I wouldn't post

Oracle question on SQL forum 😀 but on...