Forum Replies Created

Viewing 15 posts - 151 through 165 (of 7,165 total)

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    Did you post new code?

    Jeff Edited his original post.

    March 2, 2016 at 8:35 am

    #1862420

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    When I try script below but got an error said: Invalid object name '#order'

    select * from #order

    Lookup xp_cmdshell in Books Online to see the definition of the resultset it...

    March 2, 2016 at 7:33 am

    #1862386

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    There are about 5000 jpg files stored in a file server in which the length of file's name is the same.

    For example, in server order \\order\2016

    20160101.jpg

    20160110.jpg

    ...

    20160228.jpg

    How to code to...

    March 2, 2016 at 7:22 am

    #1862382

  • RE: Rollback if ETL fails

    moid.hassan (3/1/2016)

    Hi,

    Need an advice on rolling back the ETL load if anything fails.

    I have a one truncate-and-load ETL process that runs every night, it first truncates the fact tables and...

    March 1, 2016 at 7:04 pm

    #1862256

  • RE: Extracting time from datetime adds a second? Why?

    jimtimber (2/29/2016)

    Thanks for that, its similar toExcel's datedif fuction (just about). I can use that to work out the exact difference between the different stages of the calls.

    Can I please...

    February 29, 2016 at 8:27 am

    #1861815

  • RE: Extracting time from datetime adds a second? Why?

    Sergiy (2/28/2016)

    Orlando Colamatteo (2/28/2016)

    Try this instead of going straight to a string:

    DECLARE @D DATETIME = '2016-02-28 19:04:51.997';

    SELECT CAST(CAST(@D AS TIME(3)) AS VARCHAR(8));

    It returns exactly the same result as the original...

    February 28, 2016 at 9:40 pm

    #1861715

  • RE: Extracting time from datetime adds a second? Why?

    jimtimber (2/28/2016)

    Hello!

    I am trying to extract the hh:mm:ss element of a datetime column of date. The date time column has the following format "dd:mm:yyyy hh:mm:ss".

    I used the convert(varchar (8), MyColumnName,...

    February 28, 2016 at 7:08 pm

    #1861711

  • RE: Not many DR Options in this case... HELP

    michellefs (2/28/2016)

    I'm working for a customer that has 800 GB data divided in 13 DBs. The have SQL 2008 R2 standard Edition, so cluster is not an option.

    We can only...

    February 28, 2016 at 7:02 pm

    #1861710

  • RE: Error in merge statement in Tsql

    baiju krishnan (2/27/2016)

    The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE...

    February 27, 2016 at 8:02 am

    #1861629

  • RE: Please help fix this error in SSIS 2008 package, data flow..

    Jeff Moden (2/27/2016)

    Luis Cazares (2/26/2016)

    SSIS won't work correctly with temp tables. You need to use a permanent table for your script.

    Unless there's a workaround using certain settings, but I don't...

    February 27, 2016 at 7:59 am

    #1861628

  • RE: Please help fix this error in SSIS 2008 package, data flow..

    On your Connection Manager just set the RetainSameConnection property to True so the same connection is used across all your database requests.

    February 27, 2016 at 7:58 am

    #1861627

  • RE: CAST tinyint to nvarchar

    Steve Jones - SSC Editor (2/26/2016)

    BOL does note this will return an error, but the "E" in the chart is very misleading. I'd say this is one of the poorer...

    February 26, 2016 at 8:59 am

    #1861432

  • RE: Can a SQL Agent successfully run a job step that deletes that job?

    sgmunson (2/26/2016)

    Or is there an easier way to run as SSIS package just once? Don't want that package hanging around in job form...

    From what context are you trying...

    February 26, 2016 at 8:56 am

    #1861429

  • RE: Linked Servers, Views, and Stored Procedures

    Brandie Tarvin (2/25/2016)

    ...some OLTP databases reference tables in the Reporting databases.

    How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by Server A (same...

    February 25, 2016 at 7:31 pm

    #1861313

  • RE: Today's Random Word!

    ThomasRushton (2/25/2016)

    Ed Wagner (2/24/2016)

    Grumpy DBA (2/24/2016)

    Luis Cazares (2/24/2016)

    crookj (2/24/2016)

    HappyGeek (2/24/2016)

    Ed Wagner (2/24/2016)

    Champions

    Queen!!

    Dust (another one bites the...)

    Bohemian (Rhapsody)

    (Under) Pressure

    ZZ Top

    (Top) Trumps

    Triumph

    February 25, 2016 at 2:57 am

    #1860984

Viewing 15 posts - 151 through 165 (of 7,165 total)