I'm going to second what bitbucket has requested. Without full table definitions it is nearly impossible to give accurate advice.

Based on the information you have provided it...

Are there any triggers?

The command looks right to me.

Pratap,

I get a conversion error when I run your code.

Scott,

Your code is faster. Nice.

Lynn,

Sorry to hear about the accident and injury. Glad that they are not serious. Sounds like Kassondra should stay out of vehicles around holidays. Wasn't she in...

GSquared (12/29/2009)

---

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...

I don't know a way of doing this.

Are you using snapshots? If the report does not have to be real-time you could generate a snapshot and have...

What do you get if you run:

SELECT

*

FROM

sys.dm_exec_requests AS DER

WHERE

blocking_session_id <> 0

when you try to look at the database...

This article[/url] gives an introduction to writing triggers.

I don't believe that this is possible in either version of SSRS. Why do you only want "ALL" displayed in the parameter drop-down?

Are you sure the report is referencing the correct column name?

Sounds like you first need a course in triggers. Here's an introductory article on triggers[/url] that may help.

Not that I know of.

You are going to need to convert to varchar and parse the parts. It will vary based on length. So before 10 am you'll have shorter lengths for...

dbo or db_owner do have CONTROL rights and CONTROL, in my understanding, is essentially granting db_owner. You'd do this:

GRANT CONTROL ON DATABASE::AdventureWorks TO username