ben.brugman (1/6/2017)

---

Jason A. Long (1/5/2017)

If I'm understanding correctly, the objection is that the "obliterated" rows are displaying the "MaxPrevEnd" values in the NewBeg & NewEnd columns, rather than the original...

KGJ-Dev (1/9/2017)

---

Hi Luis,

thanks for the reply and i would like to put my requirement in detail. please note i have updated my sample on the first post.

select * from...

MMartin1 (1/9/2017)

---

How about

?

same...

Newbi (1/4/2017)

---

This is my stored procedure using inside my RDL Report

USE [Invoice]

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[uspInvoiceLines]

( @InInvoiceNbr int

,@InLinesPerPageint

)

AS

DECLARE @TotalRows int

DECLARE @Remainder int

DECLARE @NumPages int

DECLARE @NextPageRows int

set @TotalRows=...

Eirikur Eiriksson (1/5/2017)

---

Here is a quick solution that uses the dbo.DelimitedSplit8K function[/url]. Note that for this to work, the values cannot contain spaces!

😎

DECLARE @Text VARCHAR(256) = 'Generic="abcde" Generic="fghij" Generic="sdfsdfasdf"';

SELECT

...

TheSQLGuru (1/1/2017)

---

I'm sorry Sergiy, but that is absolutely not the case. The...

TheSQLGuru (12/31/2016)

---

Jeff:

"If the NCI had a leading column of the TrackingNumber and there's only one of each tracking number in the table, how do you figure that would result in...

Then you need to fix the code.

Look what people told you:

Jeffrey Williams 3188 (12/29/2016)

---

You need to fix this issue:

CONVERT(datetime,PackageActivityDateTime,...

TheSQLGuru (12/30/2016)

---

lmarkum (12/30/2016)

---

Sergiy (12/30/2016)

---

lmarkum (12/23/2016)

---

I also dropped the non-clustered index IX_UPSTracking on just TrackingNumber since that seemed redundant to the new clustered PK and another existing index...

lmarkum (12/23/2016)

---

I also dropped the non-clustered index IX_UPSTracking on just TrackingNumber since that seemed redundant to the new clustered PK and another existing index IX_UPSTracking on TrackingNumber,...

When you're talking to the developer, on a side note, ask them - have they ever heard about data normalization?

That boring concept really helps in preventing deadlocks.

Feel...

I've got mine removed 15 month ago.

3 days in hospital, 1 of them because the operation was delayed.

Was quite painful for a week - one of the holes did...

ben.brugman (12/22/2016)

---

But this does not give the correct number of rows.

And the data within the rows (newFromValue) does not make sense to me.

Because of the group by data gets 'lost'.

So...

ben.brugman (12/22/2016)

---

Sergiy (12/20/2016)

---

Here is something to start with:

SELECT ID, FromValue, ToValue

INTO #Periods

FROM (

SELECT 1, 2.1, 8.0

UNION

SELECT 2, 3., 4.5

UNION

SELECT 3, 4., 10.

UNION

SELECT 4, 9., 20.

) I (ID,...