Is this the point where I should facepalm my self and shout Doh! in my best Homer Simpson Impersonation?

DOH!

Since about...

I started my career as dba, and in the mean time discovered that my true calling is in fact development.

Now if my dba disables select * from any of my...

Lol, I know I have done this twice in my life. 1st time was on the dev box on a restore of production, so I could simply run a update...

Thanks, and to you guys as well!

as for the work-call free weekend.... yeah right!

It's Christmas eve in SA already, and every one is having dinner with families etc... and me......

The error line was Order By

Reasaon for that is that Order By is not allowed in function.

However the client requirement was only that the warehouse be listed 1st.

So what...

Thanks for this. I nearly used this function.

Hi,

Yes, I am in 2000.

We have started discussions for the new version of the application, and this will run on 2008, but we have not even started flowcharting yet. This...

Exactly like that, allthough the time part is not that important.

The prices are only updated once every 6 months or so and I will most likely trim and convert...

thanks.

I cannot reallypost the code as it does not belong to me.

Here is a modified version:

delete from ReportDetailTable

where ReportDetailTableID in (Some SubQuery, not to complex)

PS there is a cursor, but...

my 2c on why this is happening...

It became simply too easy to ask something on a forum, or search it on google.

Welcome to the New Generation of IT.

If you can...

DOH!

Do I feel like like an idiot or do...

Ok one more question.

How to i turn this if around to look from the other anlge?

Declare @RetailDateFrom datetime

Declare @RetailDateTo datetime

Set @RetailDateFrom = '2008-07-01 12:00:00'

Set @RetailDateTo = '2008-07-28 12:00:00'

if (@RetailDateFrom...

This is what I have, but it always prints success.

Declare @RetailDateFrom datetime

Declare @RetailDateTo datetime

Set @RetailDateFrom = '2008-07-01 12:00:00'

Set @RetailDateTo = '2008-07-28 12:00:00'

if ((@RetailDateFrom is null) AND (@RetailDateFrom is null))

OR ((@RetailDateFrom...

can a moderator please delete one post of the duplicates. After posting, I got an error:

The following error occurred...

Sorry the application encountered an unexpected error. Information about...

Ok So I'm sure some one will send an assasin my way for saying this, but:

Cursors are not always evil, and will certainly help in this instance!

You can then simply...