Viewing 15 posts - 16 through 30 (of 270 total)
How about some nice triangular joins done inside a cursor? Jeff Moden: Look Away.
December 20, 2019 at 9:10 pm
Yeah no argument that that solves the problem. I'm just still kinda surprised by how this played out and that there's no setting on the SQL Server side. But good...
September 14, 2019 at 12:35 am
So the only way to do what I want is for SSIS to notify me right off the bat if the source file has data longer than I'm expecting? It...
September 13, 2019 at 11:34 pm
Thanks, I tried that and saw that the data was NOT truncated on the SSIS side.
The source file is Excel so it's just a generic text field that SSIS considers...
September 13, 2019 at 6:25 pm
Thanks so much for the reply, but I can't see that that's the problem. Maybe you can look at these screenshots and let me know what I may be missing?
Here's...
September 13, 2019 at 3:02 pm
You can specify the package's Target Server Version. Check out this link:
Please let me know if that helps.
June 19, 2019 at 11:45 pm
It sounds like your SSIS package(s) is using Package Configurations. This is a way to set the values of variables and other elements inside the package during run time. It...
June 4, 2019 at 10:02 pm
BEGIN TRANSACTION
SELECT PrimaryKey
INTO #MyTempTable
FROM Table1
WHERE Submitted_date < DATEADD(YEAR, -3, GETDATE());
DELETE Table1
WHERE EXISTS
(
SELECT NULL
FROM #MyTempTable
...
May 30, 2019 at 10:47 pm
Or use CROSS APPLY... but the above is probably easier.
SELECT p.Id
, p.Surname
, p.Bed
, p.OpDate
, patientData.SampleDate
, patientData.BP
, patientData.Temp
FROM Patient p
CROSS APPLY (SELECT TOP 1 ID, BP, Temp,...
May 29, 2019 at 10:44 pm
Lynn-
I'm really fascinated by your solution. I don't think I've come across that concept of outer joining to the FROM table using the VALUES constructor. Is that functionally similar to...
April 23, 2019 at 11:01 pm
You need to enforce meaningful uniqueness in each row somehow. But that doesn't necessarily have to be done via the clustered index, it could be done via a non-clustered index...
April 17, 2019 at 9:32 pm
As Steve said, you really need to post some code so we can see your table structure and sample data, etc. But what John Mitchell is suggesting might be:
April 17, 2019 at 9:23 pm
Props to Drew. Was hoping I had kicked ass on this one, but not quite. Damn.
April 10, 2019 at 9:51 pm
Viewing 15 posts - 16 through 30 (of 270 total)