Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: emasik
  • Content: Threads
  • Order by date
  1. emasik

    Unique and Duplicate Records Count

    I need to return to values (@unique and @dupes). I start with: declare @unique int, @dupes int Select name, count (1) from tblTest Group by name Having count (1) > 1 However, I need total unique and total dupes from field 'name'. Any advice is welcome.
  2. emasik

    DTS Step Failed in SQL Store Procedure

    I try to execute DTS package through SQL procedure. First, I created and ran DTS in ‘Enterprise Manager’. Package executed successfully. When I call this DTS package in SQL Query Analyzer - only one step of DTS is executed (Step Create Table). Other step (Step Copy Data) is failed. Here is a...

Part and Inventory Search

Back
Top