Forum Replies Created

Viewing 15 posts - 61 through 75 (of 334 total)

  • RE: SP works in QA but not ASP/ADO...

    The message above is from the

    SELECT 'Return Value' = @return_value

    in QA and has nothing to do with the actual execution of the SP. If I comment...

    February 14, 2007 at 7:16 am

    #689697

  • RE: SP works in QA but not ASP/ADO...

    Tried both. Err.number=0 so there's no message. Changed the Select to return only the first column -- same results.

    ANy idea why I'm still getting "(1 row(s) affected)"

    February 14, 2007 at 7:11 am

    #689696

  • RE: SP works in QA but not ASP/ADO...

    I check the Return Code, the Recordcount and I dump the Parameters collection:

    Paging records returned=-1    This is rs.recordcount

    RC: :                                  No Return Code (no "return" in SP)         

    Parms:3:                             Number of Parms (correct)

    0=RETURN_VALUE-><-3         Parm 0=Return...

    February 14, 2007 at 6:30 am

    #689682

  • RE: Using SP as Data Transform Source gives no source columns

    So in order to use a Stored Procedure as the Source for a Data Transform I have to code in my SQL Query to create a temp table with all...

    December 13, 2006 at 6:27 am

    #677741

  • RE: Using SP as Data Transform Source gives no source columns

    >What works for me is to click the 'Populate from Source' button, then the >'Execute' button.

     

    Original post: "The button is there but it doesn't do anything. "

    I click Populate from Source...

    December 12, 2006 at 1:00 pm

    #677607

  • RE: Bulk Insert of 128M rows fills Log file

    Was set to Bulk Logged
    No triggers
    No replication

    ...Thought I had already dropped the PK (script was supposed to Drop the table then Create it again) but apparently it was still there....

    August 21, 2006 at 1:37 pm

    #655969

  • RE: JOIN with LIKE?

    The value of A.Squeezed already contains the wildcard (see examples above).

    July 20, 2006 at 11:05 am

    #650471

  • RE: JOIN with LIKE?

    Ooops...

    Select Distinct A.[Company Name], A.DAM, B.Acct_Number, B

    July 19, 2006 at 12:41 pm

    #650198

  • RE: JOIN with LIKE?

    select

    Distinct A.[Company Name], A.DAM, B.Acct_Number,...

    July 19, 2006 at 12:39 pm

    #650197

  • RE: JOIN with LIKE?

    Related question:

    How do I get the rows in B that are not matched by a row in A?

    July 19, 2006 at 12:31 pm

    #650195

  • RE: JOIN with LIKE?

    Duh..

     

    Thanks. That worked.

    July 19, 2006 at 12:12 pm

    #650190

  • RE: JOIN with LIKE?

    That's basically what I've been doing with no luck. Instead of theory here's the real stuff:

    Sample data from vw_CRM_Accounts:

    [Company Name]             DAM                        Squeezed

    A O Smith

    Lanphere Wendy

    AOSMITH%

    A O...

    July 19, 2006 at 11:23 am

    #650175

  • RE: Listing database size data

    Thanks for all the suggestions. I was puttering around with it from home last night and did a sp_helpdb from Master and got all the basic info I need: Name,...

    June 15, 2006 at 5:33 am

    #643916

  • RE: Dynamic SQL and Temp Tables/Table Variables

    Didn't know you could do that.

     

    Thanks. 

    May 22, 2006 at 12:58 pm

    #639351

  • RE: Passing GUID as parm to Stored Procedure

    The test GUID should have said 'BF33FA65-D558-43F5-BE47-0F0D20AB0028'.

    Turns out my problem was the Select in the SP:

          Select Fullname, Start_Date from tSearch where SearchGUID=@srch

    I actually...

    May 22, 2006 at 8:38 am

    #639288

Viewing 15 posts - 61 through 75 (of 334 total)