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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinct on third column
Hi, I have a table like this ,how to get all three columns in a SELECT query with distinct NEWORDER values : ID OLDORDER NEWORDER 4853814 NULL 1Z6W688A0196725307 4878543 NULL 1Z6W688A0497292312 4878543 798377318718 798377318718 4878543...- TekLight
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Granting Permission
Hi, I want to grant permissin to a Database developer to view the stored procedures in Sql server 2000/2005 ,He can also read the data .I can grant him datareader permission but then he can't access the procs.If I make him Db_owner it will be too much for him. can some one help me with...- TekLight
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
