Viewing 15 posts - 961 through 975 (of 1,469 total)
November 13, 2017 at 1:40 pm
This error is in your SSMS.
Close and re-open your SSMS.
October 25, 2017 at 9:12 am
I am writing a generic script for all our databases to return the value from...
October 25, 2017 at 5:19 am
In the past, I have faced a similar issue, and not been able to change the underlying procedure.
So I added an optional xml output parameter.
The pattern that...
October 24, 2017 at 2:31 pm
Create table #tablesrc (VendorId int, vendorname varchar(30), brokerfee int, aliancedate datetime, active bit, matchedstatus...
October 21, 2017 at 11:31 pm
October 21, 2017 at 12:50 am
October 20, 2017 at 1:44 pm
October 20, 2017 at 11:58 am
October 20, 2017 at 11:41 am
Create Procedure sp_Truncate_Address
@DBName varchar(30) =...
October 20, 2017 at 12:28 am
October 19, 2017 at 1:43 pm
Where there are cases of DD.MM.YYYY mixed with MM.DD.YYYY, something like this should do the trickselect PTL_StartDate
, YearPart = PARSENAME(PTL_StartDate, 1)
...
October 19, 2017 at 1:41 pm
October 19, 2017 at 11:19 am
Viewing 15 posts - 961 through 975 (of 1,469 total)