Viewing 15 posts - 256 through 270 (of 2,452 total)
ben.brugman - Thursday, March 2, 2017 9:04 AMBut there is no limitation for the length.
there must be a limit...if you have no...
March 2, 2017 at 9:14 am
March 1, 2017 at 4:11 pm
maybe ?
SELECT sp.Stockcode,
sp.Date,
sp.Price,
sp.UnitSold,
sp.Price*sp.UnitSold as SalesAmount
FROM stockandprice AS sp
INNER JOIN salestable AS s...
March 1, 2017 at 2:06 am
something like this maybe? (your declared variables didnt match your inserts)
DECLARE @starttime DATETIME, @Endtime DATETIME;
SET @starttime = GETDATE();
WAITFOR DELAY '00:00:02';
SET @Endtime =...
February 27, 2017 at 11:39 am
February 26, 2017 at 10:11 am
February 25, 2017 at 3:00 pm
just some thoughts.....
CREATE TABLE #Sample (YourOnlyColumn VARCHAR(MAX));
GO
INSERT INTO #Sample
VALUES
('02-28-2017, 04:03 AM'),
('TheNatty replied to a thread Piketted: Bottom 50%...
February 25, 2017 at 2:42 pm
February 25, 2017 at 10:12 am
February 25, 2017 at 7:47 am
February 24, 2017 at 11:52 am
suggest
lead(value,1) over (order by date) from [GIS_EDMS].[sde].[Precip_Acc] - value as result
February 24, 2017 at 11:10 am
February 24, 2017 at 8:43 am
does this help you in getting closer to your requirements?
CREATE TABLE #yourtable(
thedate DATETIME NOT NULL
,agent INT NOT NULL
,AgentName VARCHAR(11)...
February 24, 2017 at 8:26 am
Viewing 15 posts - 256 through 270 (of 2,452 total)