Forum Replies Created

Viewing 15 posts - 7,591 through 7,605 (of 13,876 total)

  • RE: Select Latest record by comparing 2 tables.

    For each combination of machine/instance?

    February 4, 2016 at 9:28 am

    #1856590

  • RE: Select Latest record by comparing 2 tables.

    kavithaje (2/4/2016)

    Sorry i did not understand clearly.

    Can you please give me some real example with the below query?

    Thanks in advance.

    Without knowing your table structures, the examples provided are as real...

    February 4, 2016 at 8:47 am

    #1856571

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/4/2016)

    Grumpy DBA (2/4/2016)

    In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point...

    February 4, 2016 at 8:10 am

    #1856548

  • RE: Select Latest record by comparing 2 tables.

    John Mitchell-245523 (2/4/2016)

    WITH Combined AS (

    SELECT Timestampcol, <other columns>, 'Table1' AS TableName

    FROM Table1

    UNION ALL

    SELECT Timestampcol, <other columns>, 'Table2'

    FROM Table2

    )

    SELECT Timestampcol, <other columns>, TableName

    FROM Combined

    John

    I think you might need to extend...

    February 4, 2016 at 8:07 am

    #1856546

  • RE: Compability level

    Edvard Korsbæk (2/4/2016)

    Well, I found the correct answer in the end.

    checked on the DB, which was used by the customer - it had level 110.

    Next question is of cause, what...

    February 4, 2016 at 6:30 am

    #1856516

  • RE: What is the True Version of Code?

    Orlando Colamatteo (2/3/2016)

    removed silly post...

    Your own, presumably? 🙂

    February 4, 2016 at 6:15 am

    #1856510

  • RE: Compability level

    You seem to have found the correct answer, using the wrong technique 🙂

    Different versions of SQL Server support different compatibility levels (see here).

    Within a SQL Server instance, databases can have...

    February 4, 2016 at 6:12 am

    #1856509

  • RE: Source control with SSIS

    Have a look at TFS Power Tools.

    You'll need to select the correct version for your environment. Once you've done that, you'll get a certain amount of TFS functionality available to...

    February 4, 2016 at 6:06 am

    #1856506

  • RE: Running SSIS packages from CMS server on target servers

    Orlando Colamatteo (2/3/2016)

    SQL_Surfer (2/2/2016)

    I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to...

    February 3, 2016 at 10:54 am

    #1856373

  • RE: FTP with Configuration Manager for Connection String

    Dave R (UK) (2/3/2016)

    Currently not running 2012 so not an option 🙁

    Really frustrated as the solution works with the one exception of multiple lines in configuration table

    OK. Then you are...

    February 3, 2016 at 10:20 am

    #1856360

  • RE: Running SSIS packages from CMS server on target servers

    I just had another idea, which may or may not work in practice.

    Create a 'master' package. This package searches a specific local folder and executes any packages it finds there.

    Deploy...

    February 3, 2016 at 10:18 am

    #1856357

  • RE: Running SSIS packages from CMS server on target servers

    SQL_Surfer (2/2/2016)

    I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to store them...

    February 3, 2016 at 10:13 am

    #1856355

  • RE: FTP with Configuration Manager for Connection String

    Dave R (UK) (2/3/2016)

    Hi all,

    a, hopefully, quick question if I may.

    I am creating packages for a client that utilises an FTP Connection Manager. I have set this up, tested...

    February 3, 2016 at 10:06 am

    #1856349

  • RE: What is the True Version of Code?

    roger.plowman (2/2/2016)

    Phil Parkin (2/2/2016)

    roger.plowman (2/2/2016)

    Phil Parkin (2/1/2016)

    roger.plowman (2/1/2016)

    below86 (2/1/2016)

    roger.plowman (2/1/2016)

    "

    Instant fail.

    You NEVER EVER EVER put a change into production without going through development/QA/approval/whatever.

    NEVER.

    Here is the reason I would NEVER EVER...

    February 2, 2016 at 7:26 am

    #1855975

  • RE: What is the True Version of Code?

    roger.plowman (2/2/2016)

    Phil Parkin (2/1/2016)

    roger.plowman (2/1/2016)

    below86 (2/1/2016)

    roger.plowman (2/1/2016)

    "

    Instant fail.

    You NEVER EVER EVER put a change into production without going through development/QA/approval/whatever.

    NEVER.

    Here is the reason I would NEVER EVER want to be...

    February 2, 2016 at 6:32 am

    #1855956

Viewing 15 posts - 7,591 through 7,605 (of 13,876 total)