cengland0 (1/5/2011)

---

I agree. I was programming in the late 70's (not SQL) so I am way older but don't want to...

Then you need to manually add the parameter to the report. In design mode, if you right click under the footer section of the report you should see a...

:w00t: Now you know why I chose Anakin Skywalker...

No you just needed to say from which table / other object to take the period from.

Wow so basically sql, even 1st commercial release, is way older than me :w00t:

Yes. You can deploy your report from bids to any server (need physical access on the machine).

You can also use the web interface from any machine to remotely change...

Assuming the parameter named period. The SQL variable will be called @period. You don't need to declare it. Juste use it directly in the query.

SELECT * FROM...

Is SQL really THAT old? :hehe:

Thanx. But what I need is to be able to control how much data I keep in the trace (above and beyond 5 files @ 20 mb).

ALZDBA (1/4/2011)

---

to import and process the default trace files have a look at

http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx

It is a good starting point to figure out when things happen !

Then start a regular trace...

Lowell (1/4/2011)

---

sc-w (1/4/2011)

---

I nearly missed that post, i tried the following but it generates an error. Any thoughts?

update dbo.wce_contact set firstname = dbo.ProperCase(firstname)

Error:

Msg 1014, Level 15, State 1, Line 1

TOP...

GSquared (1/4/2011)

---

Jeff:

I did a speed test like this:

SET NOCOUNT ON;

go

IF OBJECT_ID(N'tempdb..#Strings') IS NOT NULL

DROP TABLE #Strings;

IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL

DROP TABLE #T1;

IF OBJECT_ID(N'tempdb..#T2') IS NOT NULL

DROP TABLE #T2;

IF OBJECT_ID(N'tempdb..#T3') IS...

That has to be something else. Are you using a view?

Is the view working all by itself in a simple select statement?

Jeff Moden (1/4/2011)

---

You know me... I'll always be one of the first to come up with a Tally Table solution and (now) to avoid scalar UDF's like the plague. ...

Do you have any external suites that do maintenance...