Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alexanderthegreat
  • Order by date
  1. alexanderthegreat

    Help with Query

    SELECT ( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2) + ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2) AS TotalArtsSpending, (( SELECT SUM(S2C_TTL) FROM dbo.AES_ES_2) + ( SELECT SUM(S2C_TTL) FROM dbo.AES_HS_2)) / (Select ENROLL_TTL from AES_CONTACT_SCHOOL)AS PerPupilSpending Subquery...
  2. alexanderthegreat

    Help with Query

    SELECT ( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_ES_2 AS aes ) + ( SELECT SUM(aes.S2C_TTL) FROM dbo.AES_HS_2 AS aes ) AS TotalArtsSpending / (Select ENROLL_TT from AES_CONTACT_SCHOOL)AS PerPupilSpending Im trying to take the sum of two fields and divide by another...
  3. alexanderthegreat

    Count of No Nulls please

    I need a count of all the AES_ES records without the nulls how can I do this? SELECT dbo.AES_CONTACT_SCHOOL.SCHOOL_NAME, dbo.AES_ES_1.S1A1_D, dbo.AES_ES_1.S1A1_M, dbo.AES_ES_1.S1A1_T, dbo.AES_ES_1.S1A1_V FROM dbo.AES_ES_1 CROSS JOIN dbo.AES_CONTACT_SCHOOL
  4. alexanderthegreat

    Select Distinct Records

    Nice VonGrunt!
  5. alexanderthegreat

    Select Distinct Records

    Yes but even this query SELECT DISTINCT MIN(DISTINCT monthyear) AS Expr1, eventdate FROM dbo.newsservices GROUP BY eventdate Returns dupe values in monthyear February 2004 2/9/2004 February 2004 2/22/2004 March 2004 3/1/2004 March 2004 3/9/2004 March 2004 3/17/2004 March 2004...
  6. alexanderthegreat

    Select Distinct Records

    So say something like; SELECT MIN (monthyear), eventdate FROM dbo.newsservices ORDER BY eventdate DESC
  7. alexanderthegreat

    Select Distinct Records

    I am trying to select only the distinct monthyear from my table but I have to order it by eventdate DESC SELECT DISTINCT TOP 100 PERCENT monthyear FROM dbo.newsservices ORDER BY eventdate DESC But this what happens: monthyear eventdate May 2004 5/10/2004 April 2004 4/15/2004 March...
  8. alexanderthegreat

    Multi Language Advise

    If I had a blog lets say in English. What would be the best way to say create the same blog in spanish? Is there a way to make the default English blog Spanish by copying it and simply changing the language? Does this automatically convert English to Spanish say? Thanks Al
  9. alexanderthegreat

    Update Telephone Numbers Format Change

    Hi I want to update my feild telephone1 to look like this (XXX)-XXX-XXXX but the problem is some of the fields have two numbers like this 2126296602 2125631131 but most have just the one 2126296602 How could accomplish this? Al
  10. alexanderthegreat

    Sort Feild by 3 criteria

    I want the order by for scrollercategories.id to be 2,3,1 How would I accomplish this? SELECT TOP 200 dbo.scroller.id, dbo.scroller.srolltitle, dbo.scroller.scrolllink, dbo.scroller.scrollsource, dbo.scroller.eventdate, dbo.scroller.active,dbo.scrollercategories.scrollcategory...
  11. alexanderthegreat

    Order by active where active is 1first then where active is 0

    I want to sort the result of this view, so that it sorts by eventdate first descending and where active = 1 then where active = 0 to follow SELECT TOP 20 dbo.homepage.id, dbo.homepage.title, dbo.homepage.shortdescription, dbo.homepage.active, dbo.homepage.eventdate, dbo.homepage.image...
  12. alexanderthegreat

    Select ID from Table (Next Available)

    I want to create a select statement that will retrieve the id from a table the greatest number select id from homepage so if there are 7 records it will dispay simply the number 7 or better yet the number 8
  13. alexanderthegreat

    onChange Call URL

    Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /alain/newadmin/main.asp, line 676, column 39 Response.Write((Recordset1.Fields.Item(\"iddir_dir\").Value)) --------------------------------------^ Line 676 is: <td><select name="child" disabled="disabled"...
  14. alexanderthegreat

    onChange Call URL

    I need to apply a javascript onChange event to a drop down list called 'child' so that when it changes it passes to a url = main.asp?id=<%=(Recordset1.Fields.Item("iddir_dir").Value)%>
  15. alexanderthegreat

    Join two feilds from two tables as One

    Nice and thanks so much
  16. alexanderthegreat

    Join two feilds from two tables as One

    I have 2 tables contact and quote, each ask someone if they want to recieve more info. I want to create a query that can query both contact and quote table for those you said 'Yes' to recieve more, and join the emails together in one new feild (distinct values if possible)sort ascending SELECT...
  17. alexanderthegreat

    Find and Replace Possible

    Your the best Denis
  18. alexanderthegreat

    Find and Replace Possible

    Is it possible to do a find a replace say for example I want to change all Llc to LLC in my table garages in my field named garagename? ex:Pine Water Garage Llc
  19. alexanderthegreat

    Making Text Case PROPER

    How do I update a field so that the text is not all UPPER CASE but yet is in a PROPER text format? table= garage field= garagename Thanks
  20. alexanderthegreat

    Update date feild switch format

    Nice!

Part and Inventory Search

Back
Top