Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashtu
Starting Member
10 Posts |
 Posted - 2008-05-22 : 06:49:16
|
| hi i m working on ERP with VB.Net and SQLserver2005.i have some problem with that query.In the here is two administrator1- administrator2-HR administratorin the table,code written on login srceen and query is following.SELECT userGroupMaster.groupName FROM userGroupDetails INNER JOIN userGroupMaster ON userGroupDetails.groupName = userGroupMaster.groupName INNER JOIN UserNameMaster ON userGroupDetails.userName = UserNameMaster.UserName WHERE (UserNameMaster.UserName = '" & gl_strUserName & "')whenever i execute it then error comes due two administrator.I wanna use dataset in that query to read first administrator.Ashish |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-05-22 : 07:22:16
|
| use TOP 1 in u r select statement |
 |
|
|
|
|
|
use dataset