Tom - some sample data with expected resultsets would help...

also, what is the criteria against which the "ConcStatus = 'flag'" is currently being set ?!

Anita - for the answer to this, you must read the other "do you discuss salary" article & the ensuing posts..

PW - not sure if your post was addressed to me, but thought I'd explain what I meant when I said that I believe this column is being used both...

sarwa99 - it'd be much easier for someone to help you if you provide the DDL of your table along with some sample data and required results.

It seems that your...

Since you're a stickler AND "in charge" make the most of your powers and take the stick to any developer who slacks off...that'll discipline 'em soon enough...

Except I think that this is also an actual column name in the table( )...which's why I was confused since if they're being filtered...

Bill - not sure why you think the update queries would be "clunky"...I have a VB 6.0 front-end which uses the windows api to get the "userName" and "Now()" for...

use the convert function...

<pre class="code"

select convert(varchar, dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1, 0)), 101) As MonthEndDate

Tom - your "from" clause should come before your "where" clause...

FROM CONCTEST
Where ConcStatus = 'flag'

...

but what is your goal - I'm confused about your select which is filtering on...

If you are using QA (Query Analyzer), it should be fairly easy to identify all the syntax errors...when I ran it through the parser, the only error I got was...

Agree about "nice article" and most of what's been said...

Comments:

"I should mention that you do want to be somewhat realistic in your search. It's ok to shoot a little beyond...

I can't figure out what you're attempting to do in the earlier part of the proc (too late at night.... to delve into the...

Here's the link to auditing - part 1 of a series by Steve (Jones) to help get you started...I believe he's written 4 in all on the same topic...

Great!

There're several ways to do this but the easiest and quickest one would be via Enterprise Manager - create 2 new databases called MY_DB_dev & MY_DB_Test - Use the "Import...