what is cross server query

• RKGoriparthi

  SSC Veteran

  Points: 240

  More actions

  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

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  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

• alekya

  SSC Journeyman

  Points: 82

  More actions

  September 10, 2013 at 3:50 am

  #1648779

  ...

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  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