[VIDEO]: What is new in version 6 4 6

Hellos 
The video is frozen to only version number , audio works fine 

Thank you, we have uploaded another video

So Small SQL scripts no longer are required to be created as separate script ??

IF yes -  OMG that's such a good update 

Yes you right. We wanted to do it for a while and finally did it.
It does indeed reduce the number of scripts and makes it easier to manage. 

I tried two scripts in Embedded query , both of them are giving me same error
Parameter Convertion To Integer Has Failed: ObjectId
'' is not a valid integer value

Something wrong with my query ? 
--


SELECT TaskID, TaskDescription, PausedUntil
FROM basecamp.checklist_master
WHERE pauseduntil < CAST(GETDATE() AS DATE)
  AND is_deleted = 0;


UPDATE basecamp.checklist_master
SET pauseduntil = NULL
OUTPUT 
    deleted.TaskID, 
    deleted.TaskDescription, 
    deleted.PausedUntil AS OldPausedUntil,
    inserted.PausedUntil AS NewPausedUntil
WHERE pauseduntil < CAST(GETDATE() AS DATE)
  AND is_deleted = 0;


I also tried constructing the query from SQL Editor directly and below too fails with same output 

SELECT     TaskID,     TaskDescription,     PausedUntil FROM [items].[basecamp].[checklist_master] WHERE PausedUntil > CAST(GETDATE() AS DATE)   AND is_deleted = 0;