Hello All,
Any help on this? Please let me know

Oops, Missed it out.. Thanks for the correction.:-)

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

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

Thanks alot!

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 to...

How about if my XML is like below? Please suggest.

<MessageBody>

<Header>

<BatchGUID>b75f8f79-9c37-444c-af4a-714e42197f02</BatchGUID>

<MsgType>703</MsgType>

...

Yes, it is the format i get from UI, May be i need to have 2 more root elements, one to include all the messages and th other to hold...

twin.devil (8/10/2016)

SELECT

PromotionInd

, ISNULL(MAX(case when vChargeCode = 'BRK' then vChargeCode end),0) AS BrkChargeCode

, ISNULL(SUM(case when vChargeCode = 'BRK' then [ChrgAmt] end),0) AS BrkAmount

, ISNULL(MAX(case when vChargeCode = 'CLR' then...

Hi,

Thanks for the query, Few changes, I'm sorry for that..

I dont want the SUM of all amounts, I just need individual amounts and also the ChargeId column like in the...

Table:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DtlChrg](

[ID] [uniqueidentifier] NOT NULL,

[ChrgCode] [nvarchar](10) NULL,

[PromotionInd] [nvarchar](1) NULL,

[ChrgAmt] [decimal](15, 6) NULL

CONSTRAINT [PK_DtlChrg] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

In the previous post, I've uploaded the images to onedrive, Please have a look at it.. I dont know how to explain this, But i need to transform all the...

Hi Twin.Devil,

Here is the desired output I'm expecting from the input data that i've...

Hi,

Thanks for the reply. My sincere apologies, It is a data error while copying and pasting. I've multiple types of ChargeCodes and the charge amounts. I want all the chargecodes...

With this query, I'm able to get the records.. Can you please check this query once?

with assoc as

(

Select l.UsrIPAddress,l.Action,l.AppVersion,bl.Description, l.AppID, l.UsrLoginDate, l.UsrLogoutDate

From LOG_UsrAccess l

Cross Join UsrReportType lt

inner join LoginType bl...

Hi,

Please find the data for 2 tables below.

UsrList Table:

INSERT [dbo].[UsrList] ([UsrID], [LoginID], [UsrName], [Gender], [MailAddr], [Email], [CreatedDate]) VALUES

(1, N'B1ADMIN', B1A, B1Usr, M, NULL, b1@e.com,...

I've tried with the below query, But not able to getting records for lets say, I've a record with ID 260 which is a combination of 256 + 4,. (I...