rcooper 78099 (3/17/2016)

---

Solution Found:

;with cte as (select chppon, datediff(day,

case when chrcdt between 19000101 and 30000101 then

convert(date,cast(chrcdt as varchar(8)),112) end,

cast(CURRENT_TIMESTAMP as date)) as Age

from clmhdr

where chstat <> 'f'...

Try this:

with cte as (

select

chppon,

datediff(day, case when...

Try converting the integer values to character strings first, then to datetime.

Redgate has a tool that will do that for you, SQL Compare.

Not sure what the cost is off the top of my head.

Disclaimer: I am not a Redgate employee...

I am going to say that it depends on what your are trying to accomplish. Your question is actually a little vague on what you are trying to accomplish.

scott.t.rider (3/17/2016)

---

Is there a type that I can declare as a variable that works in an IN clause? With it accepting multiple values, I would think it is an array...

Ed Wagner (3/16/2016)

---

jasona.work (3/16/2016)

---

Shoot me, please, just shoot me...

So, several (most) of my servers have silly-small C:\ drives for the OS. This hasn't been a problem until recently, now...

VSSGeorge (3/16/2016)

---

I have been working on the code, to remove cursors.

But one cursor, still hard to remove. Please guide me on this.

If further improvements are possible, please comment on that...

yb751 (3/15/2016)

---

That's definitely the way to go if that's an option. However, I've never seen...

Lowell (3/15/2016)

---

you have to go deeper.

all that does is turn the string into a table. join that to another real table.

replace the function with dbo.DelimitedSplit8k(@Specimen,','); and CROSS APPLY...

yb751 (3/15/2016)

---

Steve Jones - SSC Editor (3/15/2016)

---

JustMarie (3/15/2016)

---

Steve Jones - SSC Editor (3/15/2016)

---

I'm sad today

One bit of advice. Work with your body shop to make sure that the repairs come...

Not familiar with the product/service or how it works. I am going to have to start leaning to a rebuild of the server that Brandie recommended. That could...

Steve Jones - SSC Editor (3/15/2016)

---

Yeah, actually a girl hit a trailer that slide over and tapped the car. Wouldn't be nearly as bad, but it clipped a coolant line,...

I am not going to agree with Brandie right off the top. What are you using for your backups? Is this system part of a high availability solution...

I have to agree with everything that has been said so far. This is going to need to be rewritten. You need to step back and work it...