sergei.gorelik (4/21/2010)

Lowell (4/21/2010)

i thought a server side trace starts when you run the command EXEC sp_trace_setstatus @traceid, 1, and runs continuously. rebooting or stopping/starting the...

Remove the hyphen between the date and time.

Wow. Stubborn as a rock also. I sure hope he hires someone to come in and secure it,...

You don't need to give admin permissions, all you need to do is to grant alter trace permissions. See this entry in BOL for how to do this.

CirquedeSQLeil (4/20/2010)

Steve Jones - Editor (4/20/2010)

I also can do a few hours per week. By my count, this should bring it up to 7?

I recently talked w/ Andy Leonard, and he was very interested in...

CirquedeSQLeil (4/20/2010)

Lynn Pettis (4/20/2010)

CirquedeSQLeil (4/20/2010)

dma-669038 (4/20/2010)

Okay, take the code I wrote above.

Change the "year" to "qq" in the two date functions, and the select @min-2/@max to the appropriate table/column. Add some code to calc the...

You don't need wildcards to use replace... it replaces all occurrances.

i.e. select REPLACE('Hello World', 'or', '12') returns 'Hello W12ld'.

So, replace(columnname, 'XVD', 'SVD') would replace all occurrances of XVD w/ SVD.

I didn't know this... just tried it out, and it does work.

Your implicit conversion comment is incorrect -...

The group by clause (in your second nested select) is referencing a column that is in a table not included in the select clause.

You might be able to avoid the...

You can use this example for how to create the missing years. If you can't get it working with this, please do as Lynn suggests, and give us table structures...

No, this is the way that table variables are supposed to work.

What you can do is change all of the "DECLARE @TABLE TABLE" statements to "CREATE TABLE #TABLE", then change...