Information générale
Forum:
Microsoft SQL Server
Titre:
Select into a table
Hi,
I have a select statement that returns a number of columns and rows. I would like to insert these rows into a resident table.
Here is an example of what I am trying to do:
SELECT Number,CreatedDate,OrderedDate,OrderCompletedDate
,(CASE WHEN (Number LIKE 'S-%' OR Number LIKE '%-C%')
THEN DATEDIFF(dd,CreatedDate,OrderCompletedDate)
ELSE
DATEDIFF(dd,OrderedDate,OrderCompletedDate)
END) as TurnAroundTime,
Status
FROM AroundTime
WHERE OrderedDate BETWEEN '08/01/2003' AND '10/10/2003'
AND Number LIKE 'TO%'
ORDER BY Number
How can I get the returned data into the resident table?
Thanks,
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement