Forum Replies Created

Viewing 15 posts - 181 through 195 (of 761 total)

  • RE: SSIS Package Inside Trigger keeps running endlessly

    Thanks GSquared......I'll add logging and trace the package. I'll get back to you on this one after I'm done with it.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 25, 2012 at 10:17 pm

    #1553026

  • RE: SSIS Package Inside Trigger keeps running endlessly

    I really don't know a lot about CLR. And I think if I start now then it would be really time consuming. So, I'd rather stick to solving this problem...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 19, 2012 at 3:12 am

    #1550762

  • RE: SSIS Package Inside Trigger keeps running endlessly

    Eugene Elutin (10/18/2012)

    Did your "above you" insisted that you should use trigger to execute XP_CMDSHELL? Or they just told you that SSIS should start as soon as records inserted?

    I...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 18, 2012 at 6:57 am

    #1550440

  • RE: SSIS Package Inside Trigger keeps running endlessly

    GSquared (10/18/2012)

    What is the SSIS package accessing the same table for? To read values out of the inserted row?

    If it's to read values out of the row, then what...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 18, 2012 at 6:55 am

    #1550436

  • RE: SSIS Package Inside Trigger keeps running endlessly

    Hi Sam,

    I changed the properties of my package as you suggested. But, it didn't improve anything. I am adding an image which shows the various current sessions on the...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 18, 2012 at 3:42 am

    #1550359

  • RE: Extracting Data from single table

    This is another way of doing it...and I guess the simplest way....:-)

    With YOURTABLE (TICKET,STATUS)

    AS

    (

    SELECT 9543,1 UNION ALL

    SELECT 9543,5 UNION ALL

    SELECT 9543,5 UNION ALL

    SELECT 9544,1 UNION ALL

    ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 18, 2012 at 1:27 am

    #1550316

  • RE: SSIS Package Inside Trigger keeps running endlessly

    Thanks a lot for the replies.

    I know that this is a bad idea, but some people above me disagree.....anyways if this doesn't work then they'll learn I guess.

    I am pretty...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    October 17, 2012 at 9:54 pm

    #1550286

  • RE: Need Help on User Tree Hierarchy with Addition/Deletion Option

    Laurie is right. Please post DDL, Sample Data and the Expected Result and we will give you a sample solution using a Recursive CTE.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 26, 2012 at 4:28 am

    #1542302

  • RE: problem in customising a result set .plz help..

    Where in the Sample Data does it show that the city is mapped to address 3??...What is the logic behind the city being mapped to Address 3 and not 1...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 10, 2012 at 3:38 am

    #1535581

  • RE: Help Required

    The following query should do it for you:

    Select a.IssID, a.subject, a.dessc,

    MAX(Case When c.new_value = 'Accept' Then b.created_on Else NULL End) As Accepted_Date,

    MAX(Case When c.new_value = 'Assign' Then b.created_on...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 6, 2012 at 4:55 am

    #1534364

  • RE: SQL help

    woody_rd (9/5/2012)

    Sorry for the confusion, guys. Let's see if this explains it better. I have come across an issue where a table logs conditions with

    a timestamp, eventid...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 6, 2012 at 1:40 am

    #1534273

  • RE: SQL help

    dwain.c (9/5/2012)

    woody_rd (9/5/2012)

    Kind of odd, that query returns 0 results.

    To which query do you refer? Mine returns 2 rows:

    EventID

    1

    2

    May be the OP means that when he applied your query...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 6, 2012 at 12:06 am

    #1534229

  • RE: string manipulation - Need help !

    ohhh!!!! yes!!....i didn't look at the logic that way...that completely missed my eye. Sorry, My Bad. I was in a hurry, I just saw the OP's post and replied without...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 5, 2012 at 2:35 am

    #1533672

  • RE: SQL help

    I really didn't understand the requirement. Would be better if you could come up with a better example. Please have a look at the link in my signature to get...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 5, 2012 at 1:44 am

    #1533657

  • RE: string manipulation - Need help !

    You can use a lot of methods to do this. It all depends on what part of the String you want to remove, the type of requirement(one time or a...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 5, 2012 at 1:34 am

    #1533651

Viewing 15 posts - 181 through 195 (of 761 total)