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