How has SSC changed my life is the real question that I asked myself when I saw this!

I have been programming for a few years now and found that my...

Thanks Steve,

That recent posts section is cool.

I'll start using that from how 🙂

HI Steve,

Sorry yeah I should have mentioned that the last site didn't have it either 😀

I was just wondering if you guys ever found time if you could add this...

I've tried this for now.

I'm not sure 100% about your joins or columns but I'm sure you'll get the jist of it:

SELECT

O.OfficeAbbr,

U.Name,

AVG(E.FinalAmount) AS Average,

COUNT(E.EstimateID) AS Number,

SUM(E.FinalAmount) AS Total

FROM Estimates E

INNER...

Is there a date column on the job table that tells you which is the most recent?

Also how does the job table link back to the other tables?

thanks

Chris

HI ,

Thanks for the reply, I was referring to the main page.

At the moment I can't see anything that tells me if it is a erply or not.

Thanks

Chris

HI there,

It seems that you already have an Identity Column on your table?

What don't you use that and then retrieve the dat from there?

Also does this have to be done...

Hi ,

I would prob create a working table to start the ID's of the records witht he Max dates for each change in the name.

I would then delete from the...

Hi There,

Just a thought.

Where are you ASP pages sitting in relation to your Database?

Also is you QA in a different location to your Database?

I know that when we access our...

Why would you want to do that?

HI ,

The only way that I know how to do this is as follows:

1 return your results to a file instead of Grid.

Or return your results to text and then...

HI ,

Have you checked your DATA?

Sometimes the Data in your char/varchars is not compatiable with a datetime variable.

Thanks

Chris

HI there,

I have tried this on SQL2005 comp mode 90 and 80 and on SQL2000 and I always get the same result.

(the one with the nulls)

I agree that perhaps there...

The variable is declared out side of the string.

Try this

set

@sql = 'update #Table2 Set romotionType=...

Hi There,

Looks like the following table

#OrderDetails

was not created with in your dynamic string, putting it out of scope of your execution string.

You could change this to a...