Forum Replies Created

Viewing 15 posts - 151 through 165 (of 389 total)

  • RE: Matched and Unmatched Rows in ssis 2005

    sqlstud (10/4/2012)

    Hi,

    Need to transfer data from database Db1 (Db1.sampletab1) to database Db2 (Db2.sampletab2) using ssis 2005.

    Condition:

    If matched data, leave as it is.

    If unmatched data, then insert the records into DB2.sampletab2...

    October 4, 2012 at 10:56 pm

    #1545887

  • RE: Today's Random Word!

    jasona.work (10/2/2012)

    SQLRNNR (10/2/2012)

    Baster

    Turkey

    World War

    October 2, 2012 at 10:02 pm

    #1544674

  • RE: SUBSTRING And CHARINDEX to find start/end of string

    ACinKC (10/2/2012)

    Hmmm....these solutions would work if "CustomerFomm" is always followed by "CustomerDOB", but I don't think we should take that as a constant (without input from the OP). Once...

    October 2, 2012 at 9:57 pm

    #1544671

  • RE: SUBSTRING And CHARINDEX to find start/end of string

    bitbucket-25253 (9/30/2012)

    Is this what you want / need ?

    SELECT SUBSTRING(@x,28+CHARINDEX ('CustomerFornm: Changed from ',@x),CHARINDEX('CustomerDOB',@X,1)-77) AS 'Is this really what you

    want?'

    Result:

    Is this really what you want?

    Harry to Ben

    Actually little...

    October 1, 2012 at 12:15 am

    #1543786

  • RE: SSIS - Import flat file with trailer

    apache626 (9/27/2012)

    I have a flat file with trailers that the total the amounts in certain columns. I need to import the trailer into a different table. How can I...

    September 27, 2012 at 9:36 pm

    #1543170

  • RE: Today's Random Word!

    opc.three (9/20/2012)

    moving-parts

    Dynamic

    September 20, 2012 at 8:48 pm

    #1540451

  • RE: unable to connect using sql authentication

    ThomasRushton (9/20/2012)

    Does your keyboard match what the machine at the other end is expecting?

    I've been bitten in the past when I was typing from my proper, sorry, UK keyboard a...

    September 20, 2012 at 1:38 am

    #1539917

  • RE: unable to connect using sql authentication

    Benki Chendu (9/19/2012)

    I have installed sql server 2008 r2 with mixed mode authentication.

    I am able to use the sa credentials from my side but when I provide the same credentials...

    September 20, 2012 at 12:03 am

    #1539897

  • RE: A Database with 70 Table

    I am not sure I am following your question. It sounds like you have some foreign keys perhaps?

    i have a table with initial Info and Table that every month become...

    September 19, 2012 at 11:46 pm

    #1539894

  • RE: Attended an Interview

    Sean Lange (9/19/2012)

    rhythmk (9/18/2012)

    Kingston Dhasian (9/18/2012)

    1.How many columns a SQL table can hold.

    2.How many string functions are there in SQL.

    3.How many non-clustered indexes a SQL table can have.

    4.What is the...

    September 19, 2012 at 10:18 pm

    #1539881

  • RE: Attended an Interview

    yes, I have accepted the offer.Though I have still time to join any 😉

    September 19, 2012 at 10:16 pm

    #1539880

  • RE: How to setup e-mail in sql server 2000

    gopal727 (9/19/2012)

    Hello,

    Any one help me,

    how to setup e-mail/sysmail in sql server 2000.

    how to re-initiate, if e-mail is not working/sending notifications,please provide me some troubleshooting commands in sql server 2000 only

    Thanks...

    September 19, 2012 at 3:49 am

    #1539461

  • RE: Attended an Interview

    Jeff Moden (9/18/2012)

    Kingston Dhasian (9/18/2012)

    1.How many columns a SQL table can hold.

    2.How many string functions are there in SQL.

    3.How many non-clustered indexes a SQL table can have.

    4.What is the port...

    September 18, 2012 at 9:34 pm

    #1539372

  • RE: Attended an Interview

    Kingston Dhasian (9/18/2012)

    1.How many columns a SQL table can hold.

    2.How many string functions are there in SQL.

    3.How many non-clustered indexes a SQL table can have.

    4.What is the port to be...

    September 18, 2012 at 9:21 pm

    #1539366

  • RE: Student Multiple attendances

    skizzly (9/18/2012)

    Hi All,

    new here so be kind....:)

    I have a task to identify all students in a dataset of 49K that have multiple open attendances at schools.

    I can pull all students...

    September 18, 2012 at 3:23 am

    #1538966

Viewing 15 posts - 151 through 165 (of 389 total)