Forum Replies Created

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

  • RE: SQL2014 Developer disable Enterprise features

    We have many projects that we run in 2014 Developer mode

    What do you mean by this?

    April 1, 2016 at 1:12 pm

    #1869256

  • RE: Preferred way to check if the rows returned for a select query is null

    SQL!$@w$0ME (4/1/2016)

    I would like to check if the results for a select query is null. If there are no rows returned print "no rows" else send an email.

    What is the...

    April 1, 2016 at 1:06 pm

    #1869253

  • RE: SSIS Performance Question - Child Packages

    larry.andrews (3/31/2016)

    I've stumbled into an unexpected situation.

    I'm observing significant performance differences depending on how a child Package is launched.

    Scenario 1 : Single Master Package calling Specific Packages

    Scenario 2 : ETL...

    April 1, 2016 at 5:24 am

    #1869097

  • RE: Bulk load error File Could Not Be Opened

    Is the file path local to the client, or the server?

    March 31, 2016 at 2:03 pm

    #1869002

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

    Very clever indeed. How would this be applied against a column in a table?

    With some difficulty. I tried a few ideas & failed. Looking forward to seeing someone else...

    March 31, 2016 at 10:42 am

    #1868956

  • RE: Non cursor based looping within a script.

    mister.magoo (3/31/2016)

    Why aren't you just doing this:

    INSERT INTO [Table] (UserID, RefID, NewValue)

    SELECT UID, RefID, 'Fixed message'

    From UserTable

    Where <Some condition>.

    Exactly what I was wondering.

    March 31, 2016 at 8:01 am

    #1868852

  • 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...

    March 31, 2016 at 6:10 am

    #1868809

  • 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...

    March 30, 2016 at 11:07 am

    #1868679

  • 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...

    March 30, 2016 at 9:18 am

    #1868650

  • 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?

    March 30, 2016 at 9:09 am

    #1868648

  • 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...

    March 29, 2016 at 3:27 pm

    #1868423

  • 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...

    March 29, 2016 at 10:45 am

    #1868331

  • 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...

    March 29, 2016 at 10:36 am

    #1868323

  • 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...

    March 29, 2016 at 5:20 am

    #1868176

  • 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...

    March 28, 2016 at 5:40 pm

    #1868115

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