Viewing 15 posts - 4,636 through 4,650 (of 13,876 total)
March 2, 2018 at 5:45 am
There may be a fundamentally different approach required here - not sure what though!
I have...
March 1, 2018 at 11:07 am
Do you have an IDENTITY column as the PK of your fact table? If so, use that to drive your looping and remove the TOP (100000)
UPDATE ...
March 1, 2018 at 6:01 am
February 28, 2018 at 11:34 am
February 28, 2018 at 9:22 am
February 28, 2018 at 7:41 am
February 28, 2018 at 7:33 am
February 28, 2018 at 7:05 am
Sql need to add automatically the numbers with sequence .
DDL is, USE [d]
GO
/******...
February 27, 2018 at 2:00 pm
February 27, 2018 at 10:12 am
What is the primary key on table MVF_Transport_Acc?
February 27, 2018 at 9:25 am
Try running this
CREATE TABLE #FileData
(
RowNo INT IDENTITY(1, 1) PRIMARY KEY NOT NULL
, FileRowID CHAR(2) NOT NULL
, FileRowData VARCHAR(20) NULL
, GroupID INT NULL
);
February 27, 2018 at 9:02 am
February 27, 2018 at 6:47 am
You need to use a technique which maintains the physical order of the rows in the file in order to be able to add any sort of grouping identifier.
The...
February 27, 2018 at 5:55 am
February 26, 2018 at 12:28 pm
Viewing 15 posts - 4,636 through 4,650 (of 13,876 total)