Forum Replies Created

Viewing 15 posts - 136 through 150 (of 326 total)

  • RE: Update All columns in table

    Try this one , It might help ;

    Merge into desttable as target

    using

    (

    select col1, col2,col3,col4,col5 from sourcetable

    except

    select col1, col2,col3,col4,col5 from desttable

    ) as source

    on target.col1=source.col1 -- (use primary key )

    when matched...

    January 29, 2013 at 3:39 am

    #1581979

  • RE: BIT Primary Key

    nice and easy ..

    thanks for the question ..

    Also, about the explanation

    The row with Comment 'row 3' is rejected by database engine because decimal integer 2 (which is...

    January 28, 2013 at 9:27 pm

    #1581880

  • RE: Inputs Required!!

    Lokesh Vij (1/27/2013)

    demonfox (1/27/2013)

    CDC is more like versioning than audit ; what does it mean by audit trail on daioy transactions ?

    does it more related to logging of transaction by...

    January 28, 2013 at 12:02 am

    #1581420

  • RE: Inputs Required!!

    Lokesh Vij (1/27/2013)

    If you are looking to audit CURD operations on tables. Like if you want to know which columns have been updated and want to know the old values...

    January 27, 2013 at 10:26 pm

    #1581407

  • RE: CHOOSE - 1

    Lokesh Vij (1/27/2013)

    Thanks Ron for another one on SS 2012.

    Though I understood the CHOOSE function well, but have to query Employee table to get the answer correctly.

    Ya , without Employee...

    January 27, 2013 at 10:20 pm

    #1581405

  • RE: Question of the day

    nice and easy ..

    thanks

    January 24, 2013 at 11:08 pm

    #1580826

  • RE: Relational Model versus XML

    Well, I got it wrong for thinking ; that the university website needs more publications and subscriptions , so better to have xml structures ; good for subscribers..

    January 24, 2013 at 11:03 pm

    #1580823

  • RE: BIT data type

    Lokesh Vij (1/21/2013)

    An easy one for the day. Looking at all the answers, it was quite obvious to find the correct one (the odd one out).

    Posting the correct link:

    http://msdn.microsoft.com/en-us/library/ms177603.aspx

    Thanks!

    +1

    January 22, 2013 at 2:52 am

    #1579501

  • RE: EOMONTH - 1

    Thanks Ron .

    January 20, 2013 at 10:03 pm

    #1579078

  • RE: Index Question

    carlecot88ssn (1/18/2013)

    I think you wrote this by mistake. And if this is the truth, why didn't you delete your post ? We should be more conscious while posting a threat...

    January 18, 2013 at 4:22 am

    #1578634

  • RE: Loading changed (delta) data into data warehouse

    scottsnyder55 (1/17/2013)

    I need to load only changed (delta) data from 3000 databases into a staging environment that will then be loaded into a data warehouse. The SQL Server versions include...

    January 18, 2013 at 4:17 am

    #1578631

  • RE: Loading changed (delta) data into data warehouse

    carlecot88ssn (1/18/2013)

    The fabric upper will provide good protection and soft touching feeling for its wearer. While the thickened Onitsuka Tiger Tokidoki Mex Lo collar and the additional small piece of...

    January 18, 2013 at 4:12 am

    #1578629

  • RE: Bug when aggregate in select?

    Jason-299789 (1/18/2013)

    Its possibly more dangerous to have a user defined objects in your Master database.

    However, I dont think its an issue when you consider it logically the sum indacates that...

    January 18, 2013 at 3:06 am

    #1578609

  • RE: Bug when aggregate in select?

    Jason-299789 (1/18/2013)

    Its possibly more dangerous to have a user defined objects in your Master database.

    Good one Jason !!! 😀 :w00t:

    January 18, 2013 at 2:57 am

    #1578605

  • RE: Nested replaces ?

    Nice problem; I guess i need to read the long detail provided ..

    Well, about the copy paste solution for the 2nd and third, I think dynamic sql could be of...

    January 18, 2013 at 2:50 am

    #1578601

Viewing 15 posts - 136 through 150 (of 326 total)