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 |
|
nanipanjakadi
Starting Member
3 Posts |
 Posted - 2008-02-29 : 16:14:48
|
| Hello guys, I need help to create a sql query my target is i need to assign multiple user to 'assignto' field dynamically.Thanks,Nani |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-29 : 16:16:18
|
| Please provide sample data with desired output. |
 |
|
|
nanipanjakadi
Starting Member
3 Posts |
Posted - 2008-02-29 : 16:23:44
|
| Hi, right now i dont have desired output but ijust need syntax for assigning multiple users to a field called 'assignto' dynamically...Thanks,Nani |
|
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-29 : 16:33:21
|
| What do you mean by "dynamically"? |
|
|
|
nanipanjakadi
Starting Member
3 Posts |
Posted - 2008-02-29 : 16:35:21
|
| dynamically means assign for multiple user at a time instead of assigning one by oneThanks,Nani |
|
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-29 : 16:38:26
|
| How are you planning on passing your list of users to the query? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-29 : 23:31:17
|
quote:
Originally posted by nanipanjakadi
dynamically means assign for multiple user at a time instead of assigning one by oneThanks,Nani
Can you illustrate with example ? I don't think any of us really understand what are you trying to do here ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-01 : 11:05:37
|
Maybe he means Update instead of Assign?UPDATE [Table]Set AssignTo = [username]FROM usernametable inner join [Table] on usernametable.[Something] = [Table].[Something]
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Need help