Viewing 15 posts - 961 through 975 (of 1,464 total)
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
October 18, 2017 at 7:48 am
Ed Wagner - Friday, October 13, 2017 1:46 PMSchool
Shoal
October 13, 2017 at 3:44 pm
You have 2 updates to the same table, with a trigger firing on each update.
I would try doing a single updateUPDATE [dbo].[UO_MList]
SET GeneralSales_HolidaySales_OptIn...
October 11, 2017 at 12:39 pm
Viewing 15 posts - 961 through 975 (of 1,464 total)