Forum Replies Created

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

  • RE: Parsing Parameters in a Stored Procedure

    Just at the time when we're trying to find a way to improve our data import this article comes along. Perhaps it is a God-send.

    While your article does not...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    November 5, 2012 at 8:16 am

    #1556069

  • RE: You Are a Professional, So Speak Up

    Thank you all for your input on this editorial, it has been a very enlightening and instructive dialog.

    My initial thoughts related to the "speak up" part of the editorial. ...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    July 31, 2008 at 9:24 am

    #851339

  • RE: Free Training

    Well said, Steve!

    Looonnnng ago, in a GUIDE conference in a city faaaarr away in a mainframe community, a presenter made some excellent points which I offer (in my own words) in addition to...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    September 25, 2007 at 6:32 am

    #735974

  • RE: Question of the Day for 29 Jan 2007

    This was an interesting question.  Such a simple thing, of course it would be 3.33333... ad infinitum.  Not so, when I tested it!  When the answer appeared, I wondered whether...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    January 29, 2007 at 7:35 am

    #686133

  • RE: The Dynamic Process of Loading Data

    I'm impressed with your article, Janet.  And I find Vincent Rainardi's experience very helpful.  Being the novice that I am with SQL DTS (I shudder when I think of DTS),...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    January 23, 2007 at 7:57 am

    #684938

  • RE: A Special Announcement from Andy, Brian, and Steve

    Good for you-all! And good for us-all.  Thanks for communicating with us, the community, and thanks for the integrity and conscientiousness to pass along the site to folks who have, as...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    November 15, 2006 at 7:32 am

    #671949

  • RE: STRANGE ERROR MSG

    The only time I've seen this "strange message" was when I was debugging code and tried to add a line of code. When I've encountered this message,...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    May 5, 2005 at 9:12 am

    #557102

  • RE: Query Challenge – Combine a column from multiple rows per item into one row per item showing each column and the sum of the columns.

    PW, well done!  Your solution is a LOT SIMPLER than the gyrations I was going through.

    Thanks

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    January 21, 2005 at 1:03 pm

    #538574

  • RE: Search for partial credit card number

    A variation of Steve's answer, plus adopting msahoo's suggestion to use '=' ... and I wonder about the performance of this option.

    SELECT CardNumber FROM CreditCardDetails

    WHERE RIGHT(CardNumber,LEN(srcharg)) = srcharg

    ... with "srcharg"...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    January 13, 2005 at 7:55 am

    #537278

  • RE: Are you innovating?

    I agree: Good article, Andy.

    I'm looking forward to the traffic signal showing how much time is left on the YELLOW (and maybe even FLASHING THE RED to STOP! STOP! STOP! before going...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    October 4, 2004 at 9:58 am

    #525255

  • RE: Automatically load DTS packages

    The forum post listed below says there is no way to export/import, but we can open the DTS package and SAVE AS to another destination (Server and/or database?).  I'm trying...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    September 22, 2004 at 9:22 am

    #524013

  • RE: upgrading from Access to TSQL

    Dear poger67, in the first reply from Steve Jones, he referred to BOL. For a long time I wondered what BOL was until I asked one of my fellow...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    December 30, 2003 at 7:59 am

    #488181

  • RE: Percentage Calculation

    Hello, Peter.

    I had a similar situation just recently.

    What worked for me was to make each count an int or bigint, and set the variable for Percent to be decimal(5,2).

    Table Variables...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    November 12, 2003 at 3:05 pm

    #481779

  • RE: Examples using Table Variables

    This posting was intended for the T-SQL group, and somehow I put it here.

    Since table variables cannot be used as inputs to functions (Antares686's reply above), the query...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    October 30, 2003 at 1:44 pm

    #480366

  • RE: Examples using Table Variables

    THANK YOU to ALL of you! What a great and rapid response!

    After I sent my cry for help, I found another person's question where he was using a table...

    Norm Johnson

    "Keep smiling ... it gives your face something happy to do
            ... and it makes people wonder what you're up to!"       

    October 28, 2003 at 7:50 am

    #479879

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