User Profile

Collapse

Profile Sidebar

Collapse
Hasse1982
Hasse1982
Last Activity: Nov 21 '08, 12:05 PM
Joined: Nov 20 '08
Location: Stavanger, Norway
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Hasse1982
    replied to Subquery with count problem
    in SQL Server
    Wow, thank you!

    It works like a charm, and the best part is that I was not completely off, it was just some paranthesis missing.
    I now just discovered one thing you might be able to help me with:
    This query: SELECT [CreatedByUser]
    FROM [DMSDB].[dbo].[KDOCUMENT]
    GROUP BY [CreatedByUser]
    HAVING COUNT([CreatedByUser])...
    See more | Go to post

      Leave a comment:

    • Hasse1982
      started a topic Subquery with count problem
      in SQL Server

      Subquery with count problem

      Hi

      I have a table KDOCUMENT with the columns
      [DocID],
      [Title],
      [CreatedByUser],
      [CreateDate],
      [LastModifiedByU serName],
      [LastModificatio nDate],
      [Comment]

      On this table I want to find the test documents so that they can be deleted, hence I have created the query to find documents with the words "test" and "delete" in [Title] and [Comment] looking...
      See more | Go to post
      No activity results to display
      Show More
      Working...