Viewing 15 posts - 961 through 975 (of 1,468 total)
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
You could also try testing for specific formatsCREATE TABLE #dates (dateString varchar(10));
GO
INSERT INTO #dates
VALUES
('03/15/2017'),
('04/18/17'),
('14.06.15'),
('27.01.2014'),
('24th May 2'),
('09.09.2015'),
('42550'),
('27.07.16');
October 18, 2017 at 1:24 pm
TRY_CONVERT is a built in SQL function ? if so, what version? I'm using...
October 18, 2017 at 1:04 pm
Viewing 15 posts - 961 through 975 (of 1,468 total)