Post reply

what is cross server query

  • January 3, 2010 at 10:25 pm

    #136979

    Hi,Good day

    anybody can provide me the details like

    a) what is cross server query

    b) how we can impliment cross server query

    Have a ncie day

    Thanks & regards

    rclgoriparthi

  • January 3, 2010 at 11:17 pm

    #1098288

    Hi, read up on it first:

    http://www.lazydba.com/sql/1__1624.html

    http://sql-server-performance.com/Community/forums/p/4085/27763.aspx#27763

    http://www.principiaprogramatica.com/?p=5

    Basically, you are querying between 2 different instances, or 2 different SQL servers.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • September 10, 2013 at 3:50 am

    #1648779

    ...

  • September 10, 2013 at 3:53 am

    #1648780

    alekya.kondam (9/10/2013)

    HI ,

    select * INTO Test FROM

    (

    select ROW_NUMBER()over(partition by customer order by customer) as counts ,customer,Contract

    from tablename

    ) A where counts > 1

    Select * from tablename where customer IN(SELECT customer from Test )

    Hope it helps 🙂 🙂

    I guess you posted in the wrong thread, because this has nothing to do with cross server querying.

    Not to mention this thread ended over 3 years ago...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply