User Profile

Collapse

Profile Sidebar

Collapse
stubailey
stubailey
Last Activity: Mar 4 '08, 03:32 PM
Joined: Feb 18 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • stubailey
    replied to Output of a query in row intead a column
    in SQL Server
    Hi,

    Have a look at pivot and cross tab. This article may help.

    http://www.databasejou rnal.com/features/mssql/article.php/3516331

    Stu
    See more | Go to post

      Leave a comment:

    • stubailey
      started a topic Timeout when specifying server name
      in SQL Server

      Timeout when specifying server name

      Hi,

      I am having real problems with timeout on queries when I specify a server and database name.
      i.e. INSERT .. SQLSERVER1.DATA BASE1.DBO.TABLE 1
      SELECT .... FROM SQLSERVER1.DATA BASE1.DBO.TABLE X

      The problem is that the stored procedure can be used over either 1 or 2 servers, when use over 2 servers as long as they are linked it is not an issue. If the server is the same then I timeout.

      The...
      See more | Go to post
      No activity results to display
      Show More
      Working...