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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-06-25 : 06:46:33
|
| how can i get the set of values from one table based on conditioninto one variable in sqlserver 2008 tables |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-06-25 : 06:55:55
|
| Can you give more detailed information ? |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-06-25 : 08:48:38
|
| Do you need this?Declare @var varchar(10)Select @var =column_name from table_name where primary_key_col=valueSelect @varSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
Arun.G
Yak Posting Veteran
81 Posts |
Posted - 2010-06-25 : 09:32:23
|
| MY TABLE STRUCTURE IS:ID CALENDARNAME LOC MON TUE WED THU FRI SAT SUN1 AAA BLR FD FD FD FD FD WE WE2 BBB CHN FD FD WE WE FD FD FDFOR THIS TABLEI WANT TO WRITE STORED PROCEDURE FOR INSERT WHERE CALENDARNAME IS DROPWDOWN LIST COMING FROM MASTER TABLE AND THEN MON,TUE,WED,THU,FRI,SAT,SUN COLUMN VALUES ALSO COMING FROM DROPDOWNLIST FROM SOME TABLEHOW TO WRITE SP TO INSERT FOR THIS TABLE ? |
|
|
|
|
|
|
getting values for one variable from table