Forum Replies Created

Viewing 15 posts - 1 through 15 (of 112 total)

  • RE: Updatable Text Boxes

    Thanks. That was what I thought but wanted to double check with you all. Unfortunately, the big wig Claims person believes it can be done after the report renders. Says...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Scrubbing Data - Good idea or bad idea?

    Thanks for all the advice. They all would work well if there was any form of procedure and accountability in the company I work with.

    I started the job almost 6...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: UDF not there or invisible

    I didn't say anything about viewing the definition of the object I said I can't see it anywhere. I know it must be a function cause I can see it...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Generate XSD using SSIS

    I there anyway to automate the creation of the XSD file. Such that when the package runs every time it will create the XSD from the XML.

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Breaking down T-SQL requirements (methodology)

    What I meant to say was everybody worth listening to :). When a person has to go back into their code after being away from it for a while it...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Breaking down T-SQL requirements (methodology)

    That is pretty much the approach I have been seeing everywhere. So I guess it is the way it is done. I just thought maybe someone would have documented a...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Breaking down T-SQL requirements (methodology)

    For your better understanding of what I am thinking it would be something like what this article covers but more in-depth - such that a book could be written about....

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: T-SQL vs SQL differences

    Love that trick. Nice!

    T-SQL and SQL certainly are different. I, therefore, would never assume someone knew TSQL just because they wrote SQL on a resume.

    TSQL to me would mean the...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: filter behaving differently from query analyser versus when called through sproc

    Using the term "Where Filter" is a pretty common way of referring to the WHERE clause conditiional filter. It maybe shorthand'ish but I don't see how anyone without putting any...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: Combining everything to present the whole picture

    herladygeekedness,

    Thanks so much for you great answer!

    Best Regards..

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: rownumber() over with insert statement

    Yes, I think that does it. That is much simpler and more elegant than what I did. Thanks to you both for your help.

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: rownumber() over with insert statement

    ...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: rownumber() over with insert statement

    I got it to work with creating a temp table and populating that with the results of my RowNumber table. May not be the most savy of code but it...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: rownumber() over with insert statement

    Thank for the reply Keith. The WHILE LOOP is needed because for each loop through it needs to create a unique company name to be used in the insert statement....

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • RE: need NULL defined when adding to the table

    Thank you. That is solid good advice. Your right best not to mess with it until clarification can be achieved.

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

Viewing 15 posts - 1 through 15 (of 112 total)