I am not at my desk, so cannot check but thoughts are:

Use an xml schema to define the data type?

Format the value in a VARCHAR variable instead of a decimal,...

How about the path to RS.exe - is that right?

declare @dob datetime,@now date

set @dob='1 jan 2012'

set @now = '31 dec 2012'

select

datepart(year,@now) - datepart(year,@dob)

+

case

when dateadd(day

...

Hi Brandie,

Your first two updates need the "Extract" column, which is not covered by the filtered indexes, so a decision has to be made whether to index seek and key...

The problem is that you can't have negative lengths or positions and you will get those, so you need to protect against them.

Try this:

select

-- uncomment the following...

I think that, if you took the time to learn what the code you already have is doing, you would have your answer.

PATINDEX tells you the location or index of...

Ooh if kludges are what we want here, I love kludges...

select months.val

from some_table

cross apply (

select 1 ,GBAN01/100 union all

select 2 ,GBAN02/100 union all

select 3 ,GBAN03/100 union all

select 4 ,GBAN04/100...

There is no need for all those joins.

select e.MSKEY

, max(case when e.ATTRNAME='FNAME' then e.AVALUE end) AS FNAME

, max(case when e.ATTRNAME='MNAME' then e.AVALUE end) AS MNAME

, max(case when e.ATTRNAME='LNAME' then e.AVALUE...

Hi,

Please read this article and post some sample data that can easily be used.

You will get help much quicker with this information.

Forum Etiquette: How to post data/code on a...

Hi, this should help:

CREATE FUNCTION FormatLakhCrores (@number SQL_VARIANT,@conversion smallint)

RETURNS TABLE

WITH SCHEMABINDING

AS

--= Function to format a number using the Lakh/Crores style

--= Written 06 Sept 2013 Mister Magoo

--= Permission granted for public...

Surely this is a case for validation at the front end?

There always used to be a rule that applications validate input...

Most likely answer seems to me to be that your data item is not a date, so using date formatting options won't work...

pietlinden (8/12/2013)

---

I was afraid I was going to have to use that. No way to pass a parameter directly to a stored procedure through the GUI. No big...

Interesting, but is it practical to try and protect every table in this way?

In case you are interested - and I am not suggesting this is any better, but for...

Jason,

Simply putting "from sys.columns" after it should be enough to get a plan.

And, no I don't have an authoritative source - boy I wish I did, so for now...