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 |
lime3003
Starting Member
1 Post |
Posted - 2013-09-11 : 07:59:42
|
Hello.I was wondering how you code to get a timestamps to a temp table.ex. select date from clock where name='name' and nbr='10';I want this data to be in my temp date table... PLZ can someone help me? |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-11 : 08:36:27
|
[code]select date INTO #YourTempTable from clock where name='name' and nbr='10';[/code]If your temp table already exists (as it will after the first time you run the above query)[code]INSERT INTO #YourTempTable (date) select date from clock where name='name' and nbr='10';[/code] |
|
|
|
|
|