User Profile

Collapse

Profile Sidebar

Collapse
KIDDLE
KIDDLE
Last Activity: Jul 12 '07, 03:56 PM
Joined: Jul 11 '07
Location: London
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • KIDDLE
    replied to Summary View Using CASE is only returning first row?
    in SQL Server
    Thanks for the reply, ended up going a complete new route to this ... Stored Procedure to return the results and then another to pull out the duplicate, changed and identical data across the two databases.

    Cheers
    Kiddle
    See more | Go to post

      Leave a comment:

    • KIDDLE
      started a topic Summary View Using CASE is only returning first row?
      in SQL Server

      Summary View Using CASE is only returning first row?

      Experts,

      Please help, I am trying to write a view that enables a list to be produced where other views in the database have a count > 0 ... but when I run this I only get a result returned for the first WHEN statement, the others are not returned, even though they have a count > 0 ?? Help please ... suggestions on approach if I am coming at this the wrong way.
      Thanks in Advance
      SELECT 'VIEWS TO BE CHECKED' =...
      See more | Go to post
      No activity results to display
      Show More
      Working...