Cat

Steve Jones - SSC Editor (2/29/2016)

---

Alan.B (2/29/2016)

It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being...

Luigi

I hadn't test...

SSIS won't work correctly with temp tables. You need to use a permanent table for your script.

Unless there's a workaround using certain settings, but I don't remember any.

SQLRNNR (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Well, that's a good thing...

This is a bit safer than Gilbert's version.

declare @test-2 table(Code varchar(18));

insert into @test-2

select aa.code from (

select '0012345678912' union all

select '00012345678912' union all

select '000012345678912' union all

select '0000012345678912' union all

select '00000012345678912' union...

Are you trying to get the median?

It might be caused by partitions. I'm not sure what do you want to do with that.

I can help you, just post sample data with CREATE TABLE and INSERT statements, so I don't waste time recreating it. You can find out how to do that in...

Ray K (2/26/2016)

---

Steve Jones - SSC Editor (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Sean Lange (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in...

Use REPLACE?

Semicolons are statement terminators not initiators.

I'm not sure if you can use a WITH inside an IF condition.

Spot

If by any chance you're working with SQL Server 2012 or later, you can use TRY_CAST or TRY_CONVERT.

That wasn't my first suggestion because this is the 2008 forum, so...