SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Timestamps to a temporary tabel?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lime3003
Starting Member

1 Posts

Posted - 09/11/2013 :  07:59:42  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3661 Posts

Posted - 09/11/2013 :  08:36:27  Show Profile  Reply with Quote
select date INTO #YourTempTable from clock where name='name' and nbr='10';

If your temp table already exists (as it will after the first time you run the above query)
INSERT INTO #YourTempTable (date) select date from clock where name='name' and nbr='10';
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000