Friday, March 5, 2010

Insert with select

trying insert some data over another table selecting with criteria?

here code snippet

INSERT INTO [dbo].[T_EWS_CalendarReminderItem]
([CalendarReminderItemGUID]
,[FK_T_EWS_CalendarItem]
,[FK_T_EWS_CalendarReminderItemStatusCode])
VALUES
('test'
,'test'
,(SELECT [CalendarItemStatusGUID]
FROM [dbo].[T_EWS_CalendarReminderItemStatus]
WHERE ([dbo].[T_EWS_CalendarReminderItemStatus].[Description]='NewEntry'))
)
GO

No comments: