Viewing 15 posts - 1,561 through 1,575 (of 4,820 total)
Here's the results of the updated code:
Contract Serial Period Period PeriodEnd StartDate CallOff Day
Number Number Group ...
April 5, 2018 at 2:36 pm
Take a look at this to start:SET NOCOUNT ON;
CREATE TABLE #Data (
SerialNumber varchar(25) NOT NULL,
ContractNumber varchar(10) NOT NULL,
StartDate date NOT NULL,
CallOffDate date NOT NULL
April 5, 2018 at 1:55 pm
DROP TABLE IF EXISTS #LoanNumber;
CREATE TABLE #LoanNumber
(
Loannumber VARCHAR(10)
, ID INT IDENTITY(10000, 1)
, GeneratedLoan...
April 5, 2018 at 1:11 pm
April 5, 2018 at 8:32 am
April 5, 2018 at 8:15 am
That looks like the answer I'm looking for, but I get an error converting...
April 5, 2018 at 6:46 am
Here's that scenario in the test data: SET NOCOUNT ON;
CREATE TABLE #tempTvol (
[Site] int,
Seq int,
Concur char(1),
[Value] float
);
INSERT INTO...
April 5, 2018 at 6:26 am
April 5, 2018 at 6:16 am
April 5, 2018 at 6:05 am
April 5, 2018 at 6:03 am
April 5, 2018 at 6:01 am
April 4, 2018 at 1:27 pm
(DATEPART("dw",[Transaction Date]) == 1 ? "Sunday" :...
April 4, 2018 at 12:51 pm
Try this: SET NOCOUNT ON;
CREATE TABLE #tempTvol (
[Site] int,
Seq int,
Concur char(1),
[Value] float
);
INSERT INTO #tempTvol
VALUES (1, 1, NULL, 1.8)
,(1, 2, 'T',...
April 4, 2018 at 12:46 pm
Viewing 15 posts - 1,561 through 1,575 (of 4,820 total)