Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 8,753 total)

  • RE: Parsing XML Blob

    Jeff Moden (3/29/2014)

    I notice that you did (what I think is) a nifty trick in the HRI(CT) CROSS APPLY that greatly simplified what I thought one might have to do...

    March 29, 2014 at 11:13 am

    #1701381

  • RE: Parsing XML Blob

    elfresco1 (3/26/2014)

    I am having problem trying to parse an XML field in a table because it is too complex for me. I need to get the data from the <HighRiskIndicators>,...

    March 29, 2014 at 6:02 am

    #1701360

  • RE: How efficiently delete the old data?

    ananda.murugesan (3/29/2014)

    DELETE FROM TBL_IMAGES where ENROLLTIME <= DATEADD (year,-5, GETDATE()) order by ENROLLTIME desc

    Pls. suggestion me, If any best method?

    Here is a method that I have used for one off...

    March 29, 2014 at 3:13 am

    #1701355

  • RE: Clustered Index Scan

    GilaMonster (3/28/2014)

    INT has a higher precedence than string, the string will convert to int, so if that is an int column (which we don't know), then the query will be...

    March 28, 2014 at 3:48 pm

    #1701337

  • RE: Clustered Index Scan

    GilaMonster (3/28/2014)

    Eirikur Eiriksson (3/28/2014)

    SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '

    Apart from not being SARGable...

    All the predicates in that query are SARGable. They're...

    March 28, 2014 at 3:11 pm

    #1701331

  • RE: Clustered Index Scan

    SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '

    Apart from not being SARGable, this query puzzles me, would you ever have a SalesID value...

    March 28, 2014 at 2:51 pm

    #1701321

  • RE: how to Create index online?

    Ranzz (5/26/2011)

    Below is the script for creating index and how can I change the script to create index onlie?

    what are benfits and disadvangates of online and offile?

    CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1]...

    March 28, 2014 at 1:31 pm

    #1701301

  • RE: how to Create index online?

    tlunsf (3/28/2014)

    Ninja's_RGR'us (5/26/2011)

    What didn't you understand in my previous post?

    What part of ONLINE = SOMETHING OTHER THAN OFF GOES HERE are you having troubles with?

    It is comments like this that...

    March 28, 2014 at 11:08 am

    #1701238

  • RE: which way is the better for 1 million records inserting into one table

    cooljagadeesh (3/27/2014)

    which way is the better for 1 million records inserting into one table

    1) insert into destination

    select * from source

    2) BULK INSERT destination

    FROM '\\computer\source.txt';

    3) BCP

    Quick...

    March 28, 2014 at 1:57 am

    #1701003

  • RE: Store a Value in a Variable

    sandeep.patel1 (3/27/2014)

    Hi Eirikur Eiriksson,

    I want to assing my Aggregate transformation output(Which Returns only one value like 5.50) into a Variable.

    How can i do this.

    I already created a variable in Package...

    March 28, 2014 at 1:26 am

    #1701000

  • RE: How do I clean old data connections out of an SSIS package?

    Well, this is what I got when I tried that:

    Error1Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)).G:\Mhub_Operations\DATA\SSIS\Archive_Snapshots\Weekly_FullSnapshots -...

    March 27, 2014 at 10:55 pm

    #1700973

  • RE: Store a Value in a Variable

    Create a variable which has high enough scope for all the tasks you want to use the variable in. Then assign the initial value to the variable where the value...

    March 27, 2014 at 2:49 pm

    #1700894

  • RE: How do I clean old data connections out of an SSIS package?

    The way I would do this is :copy the package file, open the package in a text editor, delete everything including the tags between any instances of <DTS:ConnectionManager> and <DTS:ConnectionManager...

    March 27, 2014 at 2:10 pm

    #1700877

  • RE: Copying data from one set of tables to another

    ErikMN (3/27/2014)

    Thanks for the reply, but I think you're missing one part of my scenario or I'm not quite understanding your answer. The problem with your answer is that...

    March 27, 2014 at 11:09 am

    #1700811

  • RE: escape single quote in a column

    One suggestion is to use derived column and the replace function inside the left function.

    March 27, 2014 at 10:58 am

    #1700801

Viewing 15 posts - 8,686 through 8,700 (of 8,753 total)