You cannot use an alias in a the select/where/group by you would need to repeat your calculation.

I have to ask, why is it a varchar column if it only contains dates? Do you have the ability to change it to a datetime/smalldatatime column?

Ah, that's a good one. I think the issue with that one is due to language. I think you guys...

Excellent point Steve. Another reason why you need to use the correct data type for the column in the first place.

The more I look at your code, the more I wonder what you are trying to accomplish. The sub-query you have is on the RIGHT side of a LEFT...

I'm going to preface this by saying that I am not a Sybase expert, but couldn't you put all your Sybase logic in a stored procedure and just return what...

How about checking out this thread at RedGate, it sounds similar, http://www.red-gate.com/messageboard/viewtopic.php?p=28348

Barry,

Really sorry to hear about the health issues. Get well soon. And as Grant said, you need to be able to make it to PASS so we can...

Alvin Ramard (8/20/2009)

---

Lynn, I was trying to be funny when I made the comment about off topic. 😀

Grant, your website looks better than ours. I'm getting ready to...

I don't know of any way to do this as HTML is not respected in the report and there is not a rich text box type control.

I'm not sure which would be faster. Both have advantages and disadvantages. You'll need to try both in dev.

As I think about it, I'd say the select into...

Are there any errors on the job?

Do you get any error messages?

The problem is that once you grant access how do your enforce or even monitor those policies? In reality you can't. You can run server-side traces, but when...

Unfortunately I saw this post first and answered there. You can check that out for my answer.

I did post a link to this thread in that thread to redirect...

OOPS, duplicate post. Please answer here

From BOL:

Additionally, the following Transact-SQL statements are not allowed inside the body of a DML trigger when it is used against the table or...