Viewing 15 posts - 2,011 through 2,025 (of 8,760 total)
July 19, 2017 at 6:05 am
Piling on 😉
😎
;WITH MAX_SET AS
(
SELECT
FT.Employee_SID
,MAX(FT.Team_SID) AS MX_TSID
FROM dbo.FactTable FT
GROUP BY FT.Employee_SID
)
UPDATE FT
SET FT.Team_SID = MS.MX_TSID
FROM dbo.FactTable FT
July 19, 2017 at 5:54 am
July 18, 2017 at 6:31 am
This is not enough information for a thorough advice but one idea would be to:
1. Stop the SQL Server Service
2. Copy the data file, either different name or...
July 18, 2017 at 5:47 am
Do you have the XSD...
July 18, 2017 at 3:25 am
Can you please post the DDL (create table) scripts, sample data as an insert statement and the expected output?
😎
July 18, 2017 at 1:27 am
I've attached a sample file, the actual XML is large and sensitive in nature but...
July 13, 2017 at 3:40 am
Hi Nic,
can you attach the XML as a text please?
😎
Quick thought, add "[1]" as a singleton directive.
July 12, 2017 at 8:12 am
Did a quick test and it works fine by changing the format file and the staging table
😎
Format file12.0
6
1 SQLCHAR 0 ...
July 12, 2017 at 3:44 am
spectra - Tuesday, July 11, 2017 11:21 PMCan anyone please explain what is data at rest ?
Data which is not in use...
July 12, 2017 at 2:09 am
July 11, 2017 at 8:04 am
Quick suggestion, change the "\r\n" to "\n"
😎
July 11, 2017 at 7:08 am
I am hoping someone could clarify something regarding statistics and indexes.
I've found a job...
July 9, 2017 at 6:42 am
July 9, 2017 at 6:32 am
July 9, 2017 at 6:19 am
Viewing 15 posts - 2,011 through 2,025 (of 8,760 total)