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 |
|
BBrian
Starting Member
11 Posts |
 Posted - 2005-08-11 : 11:11:51
|
| Hey,I an't figure ot a way of making this work.. The statement should explain itself. I've tried a few variations but no joy!insert into transmissions (ttype, ci_number) VALUES ('Connect Direct', (select ci_number from main where ci_name='Swift Alliance to intelliMATCH'))Thanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-11 : 16:52:12
|
 Hey, I help out when I can. Damian must have been sleeping or something.And yeah, I usually am pretty sleepless at Noon. ---------------------------EmeraldCityDomains.com |
 |
|
|
BBrian
Starting Member
11 Posts |
Posted - 2005-08-12 : 09:31:22
|
| Sorry about that. Is ther I button to delete if ido it again? Ie didn't go to the next page so I presumed it hadn't submitted and pressed again... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-12 : 16:30:50
|
| That happens sometimes and we like to make sure there is a pointer to the post where there are answers in case someone stumbles across this one. In the future, there is button in the header of your post that looks like a piece of paper with a garbage can in front of it. If you spot your duplicate before it has been answered, you can delete it. I don't think it will delete once replies have been made, but I've never tried that.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Insert question