Decoding MIME

Hello,
Can anyone tell me how to decode the MIME document produced by the Excel
Renderer?
Thanks in advance.
DarrylDarryl,
If you upgrade to SP1, you won't have to!
SP1 uses the BIF(?) format. File sizes are much smaller, it will work
with Excel 97 upwards and is actually usable.
You can buy MIME decoders but I did try using some freebie ones but
none were any good.
Regards
Chris
Darryl wrote:
> Hello,
> Can anyone tell me how to decode the MIME document produced by the
> Excel Renderer?
> Thanks in advance.
> Darryl

DECODE Statement

Is there something like the DECODE Statement in ORACLE also provided for SQL-Server?

Thanks in advance

Raimund

Look in Books On-Line for the CASE statement. You will probably want the simple CASE format. Here is an example from there:

CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END,

|||

You can also use it to have any expression in the WHEN section i.e.

CASE WHEN col1='Fred' THEN 'SIMON'

WHEN col2='Smith' THEN 'Jo

END

which means its very flexible. it will only process the THEN for the first WHEN that evaluates to TRUE

|||

Thanks it works fine.

Regards

Raimund

Debugging SPs in SQL Server 2005

Hi,
Are there any new feature for debugging non-CLR SPs in Management Studio? I
couldn't find anything in BOL.
Thanks in advance,
LeilaThere's no debugger of TSQL code in Management Studio. You have to use Visual Studio for that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Leila" <Leilas@.hotpop.com> wrote in message news:%23ZJkGf4GGHA.3000@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Are there any new feature for debugging non-CLR SPs in Management Studio? I
> couldn't find anything in BOL.
> Thanks in advance,
> Leila
>