User Profile

Collapse

Profile Sidebar

Collapse
Erenst
Erenst
Last Activity: Nov 9 '07, 01:00 PM
Joined: Nov 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Erenst
    replied to Eliminating Duplicate Rows In SQL SERVER 2000
    in SQL Server
    This is what i've done .. creating an cursor and I've used it many times, hope it can help you.


    --Declare all column names in table

    DECLARE @Column1 decimal(9), @Column2 varchar(50), ect .....

    DECLARE duplicate_curso r CURSOR FOR

    -- select all columns in table bit you must have an count column
    select Column1,Column2 , count(*) Cnt, ect ...
    from tblTable
    group...
    See more | Go to post

      Leave a comment:

    • Erenst
      started a topic Users last logon
      in SQL Server

      Users last logon

      Can any one tell me if SQL stores the last logon dat for a user and where. I would like to pull reports re users last logings to the server and then database.
      See more | Go to post
      No activity results to display
      Show More
      Working...