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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Timestamps to a temporary tabel?

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]
Go to Top of Page
   

- Advertisement -