Forum Replies Created

Viewing 15 posts - 7,351 through 7,365 (of 13,876 total)

  • RE: Convert a string with an array of variables?

    Sergiy (3/30/2016)


    Solution is suprisingly simple.

    1. Create a "translation" table:

    CREATE TABLE #Mapping (

    FromChar NCHAR(1) PRIMARY KEY,

    ToChar NCHAR(1)

    )

    INSERT INTO #Mapping ( FromChar, ToChar )

    SELECT 1, 'A'

    UNION ALL

    SELECT 2, 'B'

    UNION ALL

    SELECT...

  • RE: Convert a string with an array of variables?

    Kevlarmpowered (3/30/2016)


    Thanks... I knew there had to be an easier way. I will check to see if the 8K is installed on that server or not. Maybe I'll...

  • RE: Are the posted questions getting worse?

    Sean Lange (3/30/2016)


    Lynn Pettis (3/30/2016)


    From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly...

  • RE: Convert a string with an array of variables?

    Can you elaborate on the conversion rule?

    Does every character map to another specific character, or is its position within the string also important?

  • RE: SSIS on a dedicated server?

    sqlfriends (3/29/2016)


    I will put CPU thing on another research.

    But for implementing and upgrading to new environment, just want to know to put ssis on a separate server or on the...

  • RE: Executing SSIS package through SQL job

    ramana3327 (3/29/2016)


    It works me in this way

    Instead of running as proxy account, you can modify the SQL job enter the password at the commandline. It is working fine for me

    This...

  • RE: Creating Combined Queries

    Alan.B (3/29/2016)


    You would use AND.

    SELECT vend_id, prod_id, pro_price

    FROM products

    WHERE prod_price <=5

    AND vend_id IN (1001, 1002);

    Disagree. This requires an OR.

    select a from b where condition1

    union (should probably be union all)

    select a...

  • RE: On formatting SQL code

    diamondgm (3/29/2016)


    TomThomson (3/28/2016)


    Eric M Russell (3/28/2016)


    The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.

    You have my deepest sympathy.

    I wrote some of...

  • RE: Using JOINs with GROUP BYs

    SQL 2016 (3/28/2016)


    Sorry the my example and code did not post correctly due to me. Here is my example and 2 questions:

    SELECT customers.cust_name,

    customers.cust_id,

    Count(orders.order_num) as num_ord

    FROM customers INNER JOIN orders

    ON...

  • RE: Class Not Registered Error...

    melinda.savoy (3/28/2016)


    Yes when I click the CONNECT button in my Connect to Server dialog box.

    Thanks.

    Then I guess that there is some sort of version issue (accessing SSIS 2014 from SSMS...

  • RE: Class Not Registered Error...

    melinda.savoy (3/28/2016)


    Sorry for the non-clarification. I've got SQL Server Management Studio version 2008 R2 loaded on my laptop.

    When I try to "ADD" in my object explorer Integration Services for...

  • RE: Class Not Registered Error...

    What do you mean by this, please? What is being 'added' to what?

    When I try to add Integration Services from my desktop

  • RE: To include above details in whre clause

    Here is your query again, reformatted to help others:

    SELECT dbo.Systems.SiteNumber

    , Derived_Policy_Audit_Latest.PolicyID

    , dbo.PolicyAudit.ProductCode

    , ...

  • RE: OMG - What have they done to Stored Proc Scripts???

    matt 25763 (3/27/2016)


    The scripts are used to generate client databases. I have a software as a service product which runs on some servers. Each server holds about 25 to...

  • RE: OMG - What have they done to Stored Proc Scripts???

    May I ask what the purpose is behind these scripts? Are you using them to generate a dev database, or something similar? There may be other ways to do what...

Viewing 15 posts - 7,351 through 7,365 (of 13,876 total)