I get the same error unfortunately. Also, I'm running this as a script in a query window in SQL Server Management Studio. Do I need to execute it...

This looks like what I've been trying to show on my SQL server, but I'm getting an error:

Msg 102, Level 15, State 1, Line 17

Incorrect syntax near '?'.

Msg 137, Level...

awesome! Thanks so much

thanks so much, that seems to work!

I had to change it to:

where

dateTimeOrigination >= @StartInt

AND dateTimeOrigination <= @EndInt

AND (finalcalledpartynumber = '386' OR callingPartyNumber = '386')

to get it to work correctly.

Also,...

Thanks so much for the help, I really appreciate it. Here's what I've got, but I'm gettig an error on the conversion:

Msg 8115, Level 16, State 2,...

Yes, they appear. They appear under the sp_linkedservers procedure also, but there's no information in them as to where these linked servers are, ip address, server name, etc. ...

I have an ASPXGridView in VisualStudio (http://www.devexpress.com/Products/NET/Controls/ASP/Grid/)

This control builds grids, which is based off a view I have in SQL2k5. I needed to add a WHERE clause...

sorry about that, I should have given more info. It's actually for another application, which is handling the indexing, so it's not an issue. Thanks again!

awesome! Thank you so much, that was exactly what I was looking for.

thanks for the reply. The dates should all be the first day of the week, a Sunday. That's how we start our reporting period for each week.

2008-12-14 00:00:00.000

2008-12-21...

Thank you both for the replies, I really appreciate it.

I have 2 sql servers, each one runs an SSIS job, one runs JobA first, then when it finishes, it contacts...

Yes, thank you all very much for the help, I think I'm going to try to set job#1 to kick off job #2 when finished with sp_job_start. The only...

awesome!! Thank you so much. 2 quick questions: I also added the "run_duration" column, but is that in minutes or seconds?

Also, while our processes are linear, they...

great article, thanks. This is exactly what I am looking to do. I have several jobs here, and would like to be able to audit them. Is...

thank you!!