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:
Post a Comment