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 |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-09-11 : 20:05:22
|
| Hi Guys,I have couple of fields in a table called TEMP. ID1, ID2 and so on.ID1 ID21 5 2 43 3 4 25 1what i want is if i select 1 from ID1 and click the button then i want to display the data in GUI related to 1 in ID2.can you guys help me with the query. Appreciate your helpThanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 20:17:01
|
| SELECT ID2FROM TEMPWHERE ID1 = @idTara Kizer |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-09-12 : 00:11:59
|
Truly an inspired piece of code. I shall have to use that in my next project. Of course, only after bumping of the NZDF factor a notch...  "I have HAD it with these muthu-f$#%in' cursors in my muthu-f$#%in' database!" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 12:35:29
|
I was pretty impressed with it.  Tara Kizer |
|
|
|
|
|
|
Sql Query Help