Forum Replies Created

Viewing 15 posts - 16 through 30 (of 259 total)

  • RE: Help with Dynamic SQL

    I tried the solution you provided and this is the string it created.

    SELECT * FROM #DLFiltered WHERE Active = 1 AND CurrentLevelXID = 10 AND 1=1 AND DownlineLevel...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    July 15, 2008 at 10:13 am

    #843227

  • RE: Update with alias not working

    I have tried both version and they work kinda of.

    Update b

    SET b.SponsorXID = a.XID

    FROM [consultant].[Consultant] AS a

    ...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    July 9, 2008 at 1:45 pm

    #840484

  • RE: Update with alias not working

    Not sure I follow?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    July 9, 2008 at 12:54 pm

    #840458

  • RE: Case statment in Derived Column

    I added it as a lookup and it works fine. But I would still like to know how I can right it as a nested expression if you could help.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    July 2, 2008 at 6:31 am

    #837161

  • RE: ntext issue in Select

    I did that and it worked. Now I make that query the source for my SSIS package and I recieve the following error:

    "ResponseData" cannot convert between unicode and non-unicode string...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 20, 2008 at 12:33 pm

    #832009

  • RE: ntext issue in Select

    I found that if I CAST it as a varchar then it returns data but then the next question how will that effect the data. This query is the basis...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 20, 2008 at 12:07 pm

    #831986

  • RE: sqlcmd question

    That worked. Thanks a lot.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 11, 2008 at 7:25 am

    #827231

  • RE: sqlcmd question

    OK, I tried that example and recieved the following error:

    sqlcmd -S hqtst102D\DBA -i ListTables.SQL database="Adventureworks"

    Sqlcmd: 'database=': Invalid filename.

    Then I tried it like this:

    sqlcmd -S hqtst102D\DBA -i ListTables.SQL -v database="Adventureworks"

    and recieved...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 11, 2008 at 6:47 am

    #827201

  • RE: If statement and Filtering

    The only way I found that it might work is like this:

    DECLARE @rc INT

    SELECT @rc = Count(*) from Temp1

    IF @rc =1 AND(Select PaymentTypeXID from #Temp1 )= 3

    BEGIN

    Select...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 4, 2008 at 6:35 am

    #824116

  • RE: Determinig Fill Factor

    Great info. The article really help.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    June 2, 2008 at 2:18 pm

    #823297

  • RE: Parent Child Records in Recordset

    I think I am working myself in to this:

    Took the previous #Temp1 and filtered outthe top level kit:

    Select * From #Temp1 t1

    WHERE ParentLineItemID = 0

    OrderGroupNumber OrderNumber LineItemId ...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    May 28, 2008 at 10:50 am

    #821326

  • RE: Collation issue in Case statement

    I figured it out. It was

    ,'PaymentType' = Case

    WHEN a.PaymentTypeXID IN (0,7,9,16) THEN A.[CCName] COLLATE SQL_Latin1_General_CP1_CI_AS

    WHEN a.PaymentTypeXID IN (2) THEN 'Certficate'

    END

    Thanks

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    May 15, 2008 at 3:52 pm

    #816190

  • RE: Collation issue in Case statement

    I found the differences;

    FROMdbo.uvw_OrderGroupPayment AS A With (NoLock) -- this is a view

    INNER JOIN dbo.OrderForm AS B With (NoLock) ON

    A.ORderGroupNumber = B.OrderGroupNumber

    LEFT OUTER JOIN SharedDimension.dbo.DimPaymentType AS C With (NoLock)...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    May 15, 2008 at 2:58 pm

    #816157

  • RE: GROUP BY in Sub Query

    I ended up doing a order by and reversing the direction.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    May 8, 2008 at 10:32 am

    #812544

  • RE: Macro stops working from other workstation

    I found the issue. It was the connection string was not set correctly in the pass thru query. It was set to different ODBC name on the other workstations.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    May 2, 2008 at 10:11 am

    #810209

Viewing 15 posts - 16 through 30 (of 259 total)