Forum Replies Created

Viewing 15 posts - 241 through 255 (of 337 total)

  • RE: select UNION

    Very nice....I figured it was something simple but you never know. Thanks again Lowell. Hopefully I can return the favor one day!

  • RE: select UNION

    Lowell,

    Thanks for the reply. I know what your talking about but the error I get is not about that. I didn't post exactly what I was writing in the...

  • RE: Odd select behavior

    I thought it might be a NULL issue but didn't explore it. Will do now. Thanks for the replies.

  • RE: Getting Row ID from Upate Trigger

    I found it.   I read a little about Using the Inserted and Deleted Tables in the BOL.

    select @ID = ID from inserted

    This works within the trigger.

  • RE: Getting Row ID from Upate Trigger

    Antarres686,

    Yes I am using 2000. I'll tried that and I didn't get it to work. I'm trying to get the Identity (from the row that is being updated)  within the...

  • RE: Editing Cells

    Thanks...I'll check out that link. I don't like having to move as fast as I can and hit the stop button so I don't return every freakin row in my...

  • RE: select exec @String_Variable

     

    Thanks for the reply again. I was just reading about dropping it in QA to run it mulitple times. I'll check out the BOL as well. Thanks again.

  • RE: select exec @String_Variable

    Sergiy,

    Thanks for the reply. I've been tooling around with this a little this morning. If I run that query more than once it tells me that the object #Foo already...

  • RE: SQL Login

    Thanks much....I'm going to enforce the SSL connections. As far as EFS I'm going to apply that to the backup files at least.   20% is more than I'd like to lose...maybe I...

  • RE: SQL Login

    Yes I could install a Certificate......I could just generate a local one (we don't have a domain wide CA installed yet) but I am working on it so I can setup...

  • RE: SQL Login

    Thanks for the reply I'll check out that link. I'm assuming you can't do this but it's worth a shot.... I would like to create a domain user account add...

  • RE: Mulitple entries for one Parameter

    Thanks for the suggestions. I ended up writing a long If then Else statment. It works but I'll have to see if I can rework it using your syntax. Thank...

  • RE: Passing Login Credentials to Reporting Services

    Thanks Michael....I'll check that out. 

  • RE: Passing Login Credentials to Reporting Services

    Steve,

    Thanks as usual for the reply. I guess we could use the webservice but I'm really sure what webservice your referring too (doh)?

    I have an exsiting RS website set up that...

  • RE: Variable in Function

    Thanks PW!  Actually my query does work. The problem I was having was I didn't specify the varchar size. It needed to be the same as the table. Thank you.

Viewing 15 posts - 241 through 255 (of 337 total)