Viewing 15 posts - 976 through 990 (of 1,082 total)
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
October 2, 2007 at 2:00 am
Thanks Steve,
That recent posts section is cool.
I'll start using that from how 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
October 1, 2007 at 7:52 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
October 1, 2007 at 2:51 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 28, 2007 at 8:41 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 28, 2007 at 8:37 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 28, 2007 at 1:01 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 27, 2007 at 4:52 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 26, 2007 at 8:09 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 26, 2007 at 7:49 am
Why would you want to do that?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 26, 2007 at 6:56 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 26, 2007 at 2:11 am
HI ,
Have you checked your DATA?
Sometimes the Data in your char/varchars is not compatiable with a datetime variable.
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 26, 2007 at 12:30 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 25, 2007 at 7:30 am
The variable is declared out side of the string.
Try this
set
@sql = 'update #Table2 Set romotionType=...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 25, 2007 at 5:14 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 25, 2007 at 5:04 am
Viewing 15 posts - 976 through 990 (of 1,082 total)