Forum Replies Created

Viewing 15 posts - 331 through 345 (of 390 total)

  • RE: Finding and replacing the exact value in TSQL

    anthony.green (7/4/2012)

    REPLACE will work with underscores

    DECLARE @OrigString VARCHAR(100)

    DECLARE @SearchFor VARCHAR(100)

    DECLARE @ReplaceWith VARCHAR(100)

    SET @SearchFor ='DBName'

    SET @ReplaceWith = 'Replaced_DBName'

    SET @OrigString = 'Newdb.[DBName].dbo.TableName'

    SET @OrigString = REPLACE(@OrigString, @SearchFor, @ReplaceWith)

    SELECT @OrigString

    What about this

    DECLARE @OrigString...

    July 4, 2012 at 5:30 am

    #1508724

  • RE: Independence Day 2012

    No šŸ™

    I lost the 7 points as did not see the movie šŸ˜‰

    July 4, 2012 at 5:16 am

    #1508710

  • RE: Today's Random Word!

    Ray K (7/3/2012)

    Brandie Tarvin (7/3/2012)

    crookj (7/3/2012)

    rhythmk (7/2/2012)

    Revenant (7/2/2012)

    Brandie Tarvin (7/2/2012)

    Rumba

    Roomba

    Brazil

    brazier

    bazaar

    bizzare

    A bizzare turn of events for Azzurri in EURO 2012 and Spain proved themselves best again.A team to beat.

    Spain !!!!!

    July 3, 2012 at 10:33 pm

    #1508579

  • RE: Use of Parent Package Variable configuration.

    Koen Verbeeck (7/3/2012)

    rhythmk (7/3/2012)

    Koen Verbeeck (7/3/2012)

    Are we talking about SSIS 2012 environment variables or Windows environment variables?

    Hey Koen,

    Correct me if wrong we can't use SSIS 2012 environment variables in SSIS...

    July 3, 2012 at 3:44 am

    #1508106

  • RE: Use of Parent Package Variable configuration.

    Koen Verbeeck (7/3/2012)

    Are we talking about SSIS 2012 environment variables or Windows environment variables?

    Hey Koen,

    Correct me if wrong we can't use SSIS 2012 environment variables in SSIS 2005.

    July 3, 2012 at 1:54 am

    #1508045

  • RE: Where exists vs Where in

    Also have a look on below article.

    http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

    July 3, 2012 at 12:38 am

    #1508030

  • RE: Where exists vs Where in

    Mark Eckeard (7/1/2012)

    If I understand it correctly, "exists" stops evaluating once it hits the first true whereas "in" keeps going. To me, this makes "exists" the obvious choice between...

    July 3, 2012 at 12:28 am

    #1508028

  • RE: Today's Random Word!

    Revenant (7/2/2012)

    Brandie Tarvin (7/2/2012)

    Rumba

    Roomba

    Brazil

    July 2, 2012 at 10:41 pm

    #1508013

  • RE: Is it safe to use SET ROWCOUNT?

    Sagar Sawant (7/2/2012)

    Hi Guys...

    I am using SET ROWCOUNT because the value comes from a parameter into my procedure.

    SET ROWCOUNT @take

    SELECT * FROM Something

    SET ROWCOUNT 0

    Is it possible to another...

    July 2, 2012 at 3:51 am

    #1507663

  • RE: load textfile with fixed record lenght and no delimmiters

    eatemadnia.f (7/1/2012)

    hello guys

    i want to import a big text file with a fixed record length(288) to tables.i need to read a record and check it then call a store procedure...

    July 2, 2012 at 12:10 am

    #1507611

  • RE: How to query data with a datetime data type column with a GETDATE -1

    cadm777 (6/28/2012)

    Hello All,

    The table I need to pull data from has a column called LASTUPDATE(datetime). When a new balance is reached for the data,...

    July 1, 2012 at 2:26 pm

    #1507566

  • RE: Using a Function in a Where clause

    mgee1038 (6/30/2012)

    I don't even know who put the split function in here.

    I need to be able to get the last date earlier than a parameter entered date.

    I write a function...

    June 30, 2012 at 8:25 pm

    #1507515

  • RE: Select blocked sometimes

    denisribeiro (6/29/2012)

    Hi,

    Sometimes, some action, triggered for someone blocks the database, in other words, querys that should be executed quickly, takes too long.

    Question:

    Is there some tool that could help me to...

    June 29, 2012 at 7:21 am

    #1507125

  • RE: Order while inserting data from one table to another

    Sean Lange (6/28/2012)

    rhythmk (6/28/2012)

    Mahesh Gupta-325917 (6/28/2012)

    Iā€™m trying to insert data from 1 table to another in a specific order.

    Lets say in table1, I have data saying 4,2,3,1

    Now I need...

    June 29, 2012 at 12:05 am

    #1506946

  • RE: looping based on java..

    achen9291 (6/28/2012)

    Okay this is based off my knowledge of java because i don't know how looping works for sql. so if you know java you would understand the code alittle...

    June 28, 2012 at 11:14 am

    #1506760

Viewing 15 posts - 331 through 345 (of 390 total)