Viewing 15 posts - 5,356 through 5,370 (of 13,876 total)
ThomasRushton - Thursday, July 27, 2017 5:17 AMUpdate the metadata in the binaries...? My head hurts.
..from laughing so much.
July 27, 2017 at 6:39 am
Presumably you can write the query to get 'date last invoice loaded'.
Here is a query to get 'last billing date':SELECT
LastBillingDate = IIF(DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 24)...
July 26, 2017 at 1:47 pm
OK, but what is your question?
July 26, 2017 at 12:52 pm
July 26, 2017 at 9:20 am
July 26, 2017 at 8:30 am
July 26, 2017 at 7:46 am
Does your source table have a primary key?
Does it have DateCreated and DateModified columns?
July 26, 2017 at 7:30 am
Just in case it's a possibility for you, if you were to move to SQL Server 2016, you may find that temporal tables would provide the necessary functionality...
July 26, 2017 at 7:22 am
Your attachment / image is blank.
It's not clear what you are asking for ... perhaps the image will make it clear, but we might need more information.
July 26, 2017 at 7:18 am
This might be useful to you, if you are on 2016.
If it were me, I think I'd run a query on the source table to find something...
July 25, 2017 at 2:28 pm
SET @TableName = 'dbo.my_latestyear_' + CAST(@Year AS Varchar(4)) + '_new'
July 25, 2017 at 1:08 pm
July 25, 2017 at 12:54 pm
July 25, 2017 at 12:51 pm
July 25, 2017 at 12:28 pm
I want to create my maintenance script and the corresponding data entry to a MYSQL...
July 25, 2017 at 12:17 pm
Viewing 15 posts - 5,356 through 5,370 (of 13,876 total)