Extract filename

Quick question (with hopefully a quick answer :)
Does there exist a function that turns this:
C:\projecten\33994\400134506.doc
into
400134506.doc ?
Kind regards,
Stijn Verrept.I might suggest you are better to do this splitting at the presentation
tier. Or, if only the filename is important, store only the filename.
declare @.foo varchar(64)
set @.foo = 'C:\projecten\33994\400134506.doc'
select right(@.foo, charindex('', reverse(@.foo))-1)
http://www.aspfaq.com/
(Reverse address to reply.)
"Stijn Verrept" <stijn@.no_s.p.a.n.entrysoft.com> wrote in message
news:eBK$rMqIFHA.276@.tk2msftngp13.phx.gbl...
> Quick question (with hopefully a quick answer :)
> Does there exist a function that turns this:
> C:\projecten\33994\400134506.doc
> into
> 400134506.doc ?
> --
> Kind regards,
> Stijn Verrept.|||Aaron [SQL Server MVP] wrote:

> select right(@.foo, charindex('', reverse(@.foo))-1)
Thanks, this one worked perfect :)
Kind regards,
Stijn Verrept.sql

Exporting/downloading a .RDL

I had a close call when my local PC's drive crashed and I was afraid I'd
lost the latest copies of the reports I'd created. Turns out not to be the
case (whew!) but it left me with a question.
I'd looked around the SQL server for the .rdl files and didn't find them.
Does deploying a report to the report server mean that the .rdl is copied to
the server and then configured in the SQL database appropriately? Is so,
where is the .rdl file copied since, in the case I'd lost my local copy, I
would want to copy it from the server back onto my local machine for further
development.
If not, is there some recovery tool somewhere by some nifty programmer that
would reconstruct the report based on what SQL Server has in it's
ReportServer database?
Thanks.
JonOpen Report Manager (http://localhost/reports), select your report and
click the 'Properties' tab. You'll see a section on the page called
"Report Definition". Click the Edit link and you'll have the RDL.
Andy Potter|||That's really easy and exactly what I was looking for.
Thanks, Andy.
Jon|||In addition to the previous reply, you can use Reporting Services Scripter
to dump out all your reports
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Jon Limmer" <jonlimmer@.hotmail.com> wrote in message
news:eFtdTEGHGHA.3100@.tk2msftngp13.phx.gbl...
>I had a close call when my local PC's drive crashed and I was afraid I'd
>lost the latest copies of the reports I'd created. Turns out not to be the
>case (whew!) but it left me with a question.
> I'd looked around the SQL server for the .rdl files and didn't find them.
> Does deploying a report to the report server mean that the .rdl is copied
> to the server and then configured in the SQL database appropriately? Is
> so, where is the .rdl file copied since, in the case I'd lost my local
> copy, I would want to copy it from the server back onto my local machine
> for further development.
> If not, is there some recovery tool somewhere by some nifty programmer
> that would reconstruct the report based on what SQL Server has in it's
> ReportServer database?
> Thanks.
> Jon
>
>