Forum Replies Created

Viewing 15 posts - 211 through 225 (of 667 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/10/2012)

    Jan Van der Eecken (5/10/2012)

    Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.

    Liked Eugene's dbo.p_ShowMeWhenICanGoHome though....

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 4:02 pm

    #1486023

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/10/2012)

    Someone brought a baby in to work! I want to go to Germany and see my grandson! :exclamationmark:

    Don't say you start behaving like these hysterical women...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 3:59 pm

    #1486022

  • RE: Are the posted questions getting worse?

    Nah, he's not going to come back. I'm sure he'll start another thread very soon and get some other victims attracted.

    Liked Eugene's dbo.p_ShowMeWhenICanGoHome though. Yeah, it was a pile-on, but...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 3:53 pm

    #1486019

  • RE: EXECuting a dynamic string

    Darryl, did this help at all? If not, please come back and ask, we're all happy to assist.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 3:20 pm

    #1486006

  • RE: SELECT * usage

    Yet another reason never to do a SELECT *.

    Great question, Wayne! And although I found the reference that Koen supplied, I still got the answer wrong. Anyhow, I learned something....

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 9:22 am

    #1485780

  • RE: EXECuting a dynamic string

    Here is an example:

    DECLARE @ReturnValue int

    DECLARE @SqlStmt nvarchar ( 1024 )

    DECLARE @MyParams nvarchar ( 1024 )

    SET @SqlStmt = N'SELECT @CountOfRows =...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 8:04 am

    #1485722

  • RE: EXECuting a dynamic string

    Oops, Drew beat me by a few milliseconds 😛

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 7:12 am

    #1485677

  • RE: EXECuting a dynamic string

    Have a look at sp_executesql in BOL.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 10, 2012 at 7:11 am

    #1485676

  • RE: what does 'type' in syscolumns correspond to ?

    GilaMonster (5/9/2012)

    Jan Van der Eecken (5/9/2012)

    GilaMonster (5/9/2012)

    Rather don't use the information schema either, unless you need code that's compatible across database platforms...

    Why are you saying that, Gail?

    Because they only show...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 9, 2012 at 8:44 am

    #1485102

  • RE: what does 'type' in syscolumns correspond to ?

    GilaMonster (5/9/2012)

    Rather don't use the information schema either, unless you need code that's compatible across database platforms...

    Why are you saying that, Gail?

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 9, 2012 at 7:40 am

    #1485044

  • RE: Are the posted questions getting worse?

    Doens't have to be managed C++ BTW, C# or VB.NET that thunks "down" should do just fine 😀

    Edit: Thought I'd better put quotes around "down". My fellow C programmers might...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 7, 2012 at 4:02 pm

    #1484267

  • RE: Are the posted questions getting worse?

    Revenant (5/7/2012)

    The only way around it -- don't quote me on that <g> --, would be to run a managed C++ assembly that would call an unmanaged assembly. It...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 7, 2012 at 3:58 pm

    #1484264

  • RE: Are the posted questions getting worse?

    GilaMonster (5/7/2012)

    Revenant (5/7/2012)

    Jan Van der Eecken (5/7/2012)

    Would certainly be great fun writing writing a CLR UDF in C. Maybe with a bit of embedded ASM inside? I'm sure it can...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 7, 2012 at 3:54 pm

    #1484262

  • RE: Primary Key column also a Foreign Key column in same table...

    Wow, Rich, your two threads are certainly not of the kind one would expect on a Newbies thread. Seems you have all the right questions and the accompanying answers already...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 7, 2012 at 3:42 pm

    #1484258

  • RE: Self Join

    CELKO (5/6/2012)

    What you did post was not normalized. Jobgs are entities, personnel are entities and they have a relationship. Here is a skeleton that you can use to do...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 7, 2012 at 3:11 pm

    #1484249

Viewing 15 posts - 211 through 225 (of 667 total)