Forum Replies Created

Viewing 15 posts - 16 through 30 (of 41 total)

  • RE: MY XML is not working

    Thanks

    It is now working. Only a small 's' was making my life in danger. Thanks buddy.

    October 18, 2013 at 4:05 am

    #1659626

  • RE: MY XML is not working

    Hi

    it is now working

    DECLARE @xmlDoc XML

    WITH XMLNAMESPACES ('urn:swift:saa:xsd:saa.2.0' AS Saa)

    SELECT @xmlDoc =(select

    '2.0.2' 'Saa:Revision',

    DbtrAcct_Id_IBAN 'Saa:Header/Saa:Message/Saa:SenderReference',

    1 'Saa:Header/Saa:Message/Saa:MessageIdentifier',

    'camt.056.001.01'...

    October 18, 2013 at 3:53 am

    #1659620

  • RE: MY XML is not working

    Thanks for your reply

    But I am now getting error

    Column name 'Saa:Header/Saa:Message/Saa:NetworkInfo/Saa:SWIFT:NetNetworkInfo/Saa:FileDescription' contains an invalid XML identifier as required by FOR XML; ':'(0x003A) is the first character at fault.

    Please help!

    October 18, 2013 at 3:29 am

    #1659615

  • RE: Want to add Text data

    Sorry For using the word 'it'.

    Actually the code what SScrazy sent to me is working for me.

    That's why I wrote it is working for me.

    If I hurt you...

    September 20, 2013 at 12:28 am

    #1651778

  • RE: Want to add Text data

    Thanks guys for your input

    It is working awesome!!

    September 19, 2013 at 5:41 am

    #1651459

  • RE: String as a date format

    Thanks a lot!!!

    September 12, 2013 at 1:33 am

    #1649597

  • RE: How to Remove an Instance from SQL Server 2012

    Hi SSC,

    thanks for your reply

    this video is working fine for me. Now I am able to uninstall an Instance from SQL server 2012

    [/url]

    September 6, 2013 at 1:05 am

    #1647932

  • RE: Add Check Constraint in Two Columns

    Hi All,

    Sorry for misguiding. My requirement is that when emp_id will be 1 and isdeleted = true then we will be able to insert multiple entries. when emp_id will be...

    August 16, 2013 at 4:54 am

    #1642081

  • RE: Add Check Constraint in Two Columns

    Yes you are right.

    Sorry for misguiding.........

    August 16, 2013 at 2:19 am

    #1642018

  • RE: Top from store procedure

    Hi All

    Thanks for your response....

    it is now now working. I have used the below one

    SELECT top 1* from OPENQUERY ([localhost],

    'EXECUTE [ap_stuartandParker].[dbo].[Bacs_ValidProcessingDateList]' )

    August 5, 2013 at 2:33 am

    #1638535

  • RE: How to Add a Date randomly

    Hi All,

    Thanks for your response....

    Yes I have run a loop like below

    declare @i int=900000

    declare @mydate date=getdate()

    while @i>0

    begin

    set @mydate= dateadd(day,-1,@mydate)

    print @mydate

    set @i=@i-1

    end

    However it is not working as the...

    July 4, 2013 at 11:15 pm

    #1629927

  • RE: Top One by one

    Hi Mark,

    Thanks for your reply. FETCH option is good but I am using 2008R2. Here I will not get this option.

    July 1, 2013 at 6:17 am

    #1628673

  • RE: Top One by one

    Hi,

    Thanks for your quick reply.

    It will help me as a temporary solution. I am not getting exactly 10,000 records.

    However Thanks for you reply

    July 1, 2013 at 6:14 am

    #1628671

  • RE: Top 2 with Count

    hi All,

    Thanks for your reply. it is now working fine

    @kapil: your code has helped a lot. Thanks buddy.

    June 30, 2013 at 10:30 pm

    #1628592

  • RE: Top 2 with Count

    thanks...got it

    June 28, 2013 at 5:48 am

    #1628260

Viewing 15 posts - 16 through 30 (of 41 total)