EDIT: oops...wrong thread

Any ideas?

http://www.sqlservercentral.com/Forums/Topic1128502-391-1.aspx

sturner hit the nail on the head...we must have been working on this at the same time

Thanks, but a picture is not going to help much. Can you please save off the plans as .sqlplan files and attach those?

SSIS is type-safe and is fussy about implicit conversions from one data type to another which is what you;re experiencing. Basically, in all the cases you mentioned, it's complaining about...

It sounds a little bit like you're aiming to re-invent the wheel...are you sure this is something you want to give users the ability to do?

If you must, then here...

Doing a text compare these are the only diffs:

|--Top(TOP EXPRESSION: ((2)))

...

Oops, I neglected to mention one thing...I changed the variables from Int32 to Double. Please do that and you'll hopefully see what I see.

satishchandra (6/20/2011)

---

create Function fn_test(@TestCol int)

returns table

as

If (@TestCol =1)

select 'Abc' as Col1

else

select 'xyz' as Col1

-----Gets the following error

Msg 156, Level 15, State 1, Procedure fn_test, Line 6

Incorrect syntax near the...

See if something along these lines will work:

kramaswamy (6/20/2011)

---

Haha, wow, that is one cute solution. Faking the system into thinking the string is referencing a database table, and then using PARSENAME to display the name of the...

SQL is a declarative language, i.e. this does not work:

DECLARE @SortOrder NCHAR(4),

@SortColumn SYSNAME ;

SET @SortOrder = 'ASC' ;

SET...

Will dot ( . ) ever naturally appear in the string?

If not then something like this may work:

SELECT PARSENAME(REPLACE('RNL00:123456-3:1', ':', '.'), 1),

...

I am...

You may want to have a look at master.sys.xp_enumerrorlogs. It's undocumented (means unsupported by Microsoft so don't call them if you have an issue, or me for that matter ;-))...