As Luke has said there is nothing in the query that would omit rows being returned when there are NULL values in any of the columns. Now if you...

Duplicate post. Please see this thread for answers.

I don't think it can hurt to have experience in other areas, both technical and business. One of my favorite things about working in IT is that I as...

Change Update ORders to update O

mstjean,

Probably a good idea. In my experience the user usually enters a day without time, but to be safe a conversion like you suggest would be good.

Check out Brian's video on SQLShare as there are some gotchas.

Got this from Brian Kelley. sys.sql_logins is the new view in 2005.

I'd go for it. It can't hurt too much. 😛

I don't know what sp_active does since it is a custom stored procedure, but you could look at sp_lock.

I don't think that SSRS exposes that property. I think the only cell property that is exposed is Value.

I think you'll have to do it all in a script component. Read the file and then do the insert into the destination.

In SQL Server you can do something like this:

UPDATE Orders

SET precost = O2.cost

FROM

orders O JOIN

orders O2 ON

...

What is the database context the job is executing in?

Have you checked to see what else is running at the time the job is running the procedure? It could be being blocked by another process. You can...

What controls are you using to render the report? To my knowledge there is no way to restrict a report to being one page. SSRS automatically rolls...