Just Wrap the cte in a CREATE VIEW satatement and from Crystal just use the view.

hope is clear.

Note that those values are populated at will by the client application ( in the connection string )

Yes you are. You can even...

joachim.verhagen (10/17/2007)

---

Those parameters mean a dynamic cursor. I changed @p2 that is the scroll-options to static or forward-only and @p4, that is the concurrency option to read-only it works...

in addition setting the 'trunc. log on chkpt.' to true is almost equivalent to change recovery mode to Simple wich also can have catastrofic implications at recovery time.

-Noel

error code: '5'. implies Access Denied.

Check the File access permissions that the SQL Agent Account has on the file(s)/Folder(s) you are trying to access

I addition you should code your trigger to be "multi-row" aware always.

In your TRIGGER at the begining

do something like this:

IF @@NESTED_LEVEL > 1

BEGIN

RETURN

END

BOOKS ONLINE is your best friend 🙂

The correct "casting" function should be STR.

DECLARE @fl AS FLOAT

SET @fl = 789512385

SELECT str(@fl,9,0)

you can also pass the parameters of the "function" to the stored procedure and use

CROSS APPLY operator to get the desired results

Olga,

You should follow the syntax "EXACTLY" as was posted above if you need a different ORDER BY just supply it at the end of the CTE.

EX:

create table steps (from_step_id int,...

Brandon Forest (10/16/2007)

---

I have large ETL processes that can swell the transaction log to ~50GB. We have a seperate Log drive with 100GB of room (2 x normal capacity)....

In addition you should talk to your "clients" and find out what "percent" increase are they expecting in their business and factor that in!

I also go for the double rule...

rhat (10/16/2007)

---

In six years, I've used them twice, and both times I had time (a minute or two) to look them up first and make sure I was using...