Can you give a good example of some of the multi-valued parameters that you have used dynamic SQL for? I mean, I have plenty of multi-valued parameter reports that do...

xsevensinzx (9/21/2015)

---

Jason A. Long (9/21/2015)

---

I think it depends a lot on what the SQL is being used for...

Personally I write a lot of report procs that can have a several...

It would be helpful if you were to supply some representative test...

I think it depends a lot on what the SQL is being used for...

Personally I write a lot of report procs that can have a several optional/multi-valued parameters. For those,...

Unfortunately, miskeyd CPT codes are tough to deal with. Legitimate CPT codes can and do begin with leading 0's and removing them can cause them to change meaning.

Here's a bit...

It's simply a renamed version of Jeff Moden's DelimitedSplit8k function. It was renamed to fit an existing...

I won't call this an elegant solution by any stretch of the imagination, but it's the only "1:00 am" solution that's coming to mind at the moment...

IF OBJECT_ID('tempdb..#temp') IS NOT...

Good catch! here's another attempt using CTE...

IF OBJECT_ID('tempdb..#months') IS NOT NULL

DROP TABLE #months;

create table #months...

Something like this???

IF OBJECT_ID('tempdb..#months') IS NOT NULL

DROP TABLE #months;

create table #months (

jan float,

feb float,

mar float,

apr float,

may float,

jun float,

jul float,

aug float,

sep float,

oct float,

nov float,

dec float);

insert into #months values(1.22,4.55,6.13,0,0,0,0,0,0,0,0,0);

insert into #months...

reynoso.gonzalez (9/17/2015)

---

Good morning,

I would like to know how I can make a script in SQL Server you can determine the difference days with bills based on date.

I show you an...

What the heck... I'll put a dog in the hunt...

CAST(CAST(VHRGDT AS CHAR(8)) + ' ' + STUFF(STUFF(RIGHT('0' + CAST(VHRGTM AS VARCHAR(6)), 6), 5, 0, ':'), 3, 0, ':') AS...

Looks like you have a real head scratcher on your hands... Nothing else comes to mind at the moment...

Something like this?

DECLARE @searchParam VARCHAR(100);

SET @searchParam = 'search text';

IF @searchParam LIKE '% %'

BEGIN

PRINT 'Not Working'

END

ELSE

BEGIN

PRINT 'Working'

END;

No conversion is taking place when I test your code... Perhaps different collation settings???

(I tested with SQL_Latin1_General_CP1_CI_AS)

Sean Lange (9/16/2015)

---

I don't know why so many developers want everything in sql wrapped up in a single procedure but have no problem creating 10,000 class files. It makes no...