use Charindex function to find the spaces, and substr to peel off the first
char after spaces... You will have to handle the first character, and not go
past the last..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
[quoted text, click to view] "===Steve L.===" wrote:
> i'm new to sql2k5 and reporting services 2k5.
> is there a way to automatically stagger various scheduled deliveries?
> or to check certain things, for example, a temp table needed to be
> populated before the report is generated, or stop the rest of
> deliveries if one of them failed and so on. something like a process
> monitoring in informatica.
>
> does intergration services has that ability?
>
> thank you!
>
> Steve
>
eh?????????????????????????!
[quoted text, click to view] Wayne Snyder wrote:
> use Charindex function to find the spaces, and substr to peel off the first
> char after spaces... You will have to handle the first character, and not go
> past the last..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
>
> "===Steve L.===" wrote:
>
> > i'm new to sql2k5 and reporting services 2k5.
> > is there a way to automatically stagger various scheduled deliveries?
> > or to check certain things, for example, a temp table needed to be
> > populated before the report is generated, or stop the rest of
> > deliveries if one of them failed and so on. something like a process
> > monitoring in informatica.
> >
> > does intergration services has that ability?
> >
> > thank you!
> >
> > Steve
> >
> >
Don't see what you're looking for? Try a search.
