Did you copy and paste my code and tried it?

My results are:

c1c2Termstotal

533RobinNULL533.00

655SteveNULL655.00

Sorry the VARCHAR(6) should have been a giveaway.

Hmmm...with the IF statement being Identical it is puzzling but without any more info I'm not sure.

Just another shot in the dark here...

Try this:

--Create table test

CREATE TABLE [dbo].[test](

[c1] [varchar](30) NULL,

[c2] [varchar](20) NULL

) ON [PRIMARY]

--Insert values in to the test table

Insert into test values ('533','Robin')

Insert into test values ('655','Steve')

GO

--Create View

create view [dbo].[test_vw]

as

select *,...

Are you sure your predicates are identical in both IF clauses. In your test you set your parameters but I can't tell if you used those exact values in...

The database size will not change no matter how many rows you delete. To better understand this you should do some research on how SQL actually stores data. ...

RP_DBA (6/16/2015)

---

Using Jun 1 and Jun 8 as your dates, DATEDIFF would meet 7 day criteria but includes weekends. Something like this might work?

DECLARE @StartDate DATE = '20150601'

,@EndDate DATE =...

This should work:

NOTICE - I purposely created a gap for CBA to demonstrate.

DECLARE @test-2 TABLE ([Index] INT, FactorS NVARCHAR(3), Value DECIMAL(2,1), [Date] DATE)

INSERT INTO @test-2 ([Index],...

GilaMonster (6/16/2015)

---

Unless I'm missing something, LAG won't produce the results...

EDIT: Sorry I misunderstood the question.

Robert klimes (6/16/2015)

---

you are not very clear in what your requirements are? you want to determine the lag values in reference to what?

read the post at the link in my...

Fairly straightforward, try this:

SELECT

MRN,

DischargeDate,

ApptDate,

DATEDIFF(dd,DischargeDate,ApptDate) AS DayDifference

From

Test

WHERE

DATEDIFF(dd,DischargeDate,ApptDate) <= 7

LOL, I feel like I'm answering a question for a former employer. (I used to be in Healthcare)

6 single quotes does work as a replacement string because...

'<-Outside quotes contain your string->'

The 2nd & 3rd '' will become a single quote because the 2nd is used to...

It's a little tricky to demonstrate because you have to escape the single quote in the example itself but the execution is fairly simple.

DECLARE @quotedString NVARCHAR(10) = 'ABC''DEF''GHI'

SELECT REPLACE(@quotedString,'''','"');

Darn...missed that in the OP

Did you try using GO?

Example:

First SP

GO

Second SP