Viewing 15 posts - 3,976 through 3,990 (of 13,877 total)
INSERT scripts can be generated from SSMS, though it's not entirely intuitive how you do it.
Please take a look here.
October 17, 2018 at 5:36 am
DELETE FROM dbo.Table
WHERE (YEAR(CONVERT(datetime, CONVERT(char(8), FILE_DATE))) = YEAR(GETDATE()))works pretty well. I know this...
October 17, 2018 at 5:30 am
October 17, 2018 at 5:23 am
... check for files with the current date ...
What do you mean by this?
October 17, 2018 at 5:20 am
October 16, 2018 at 1:34 pm
October 16, 2018 at 9:09 am
October 16, 2018 at 9:01 am
so I have the following problem: I have a Dataflow which picks up FILE_DATE...
October 16, 2018 at 7:05 am
October 16, 2018 at 5:33 am
I have created the following SQL statement which works fine. However, it would...
October 15, 2018 at 6:26 am
I wanted to compare 3 variables and set a flag if any of the three...
October 15, 2018 at 5:20 am
October 14, 2018 at 6:19 pm
October 12, 2018 at 8:48 am
I am executing an SSIS package which directly jumps from a script task to the...
October 12, 2018 at 6:34 am
--Deleted
October 12, 2018 at 4:58 am
Viewing 15 posts - 3,976 through 3,990 (of 13,877 total)