Search results for 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...

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...

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

Nice VonGrunt!

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...

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

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...

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

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

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...

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...

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

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"...

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)%>

Nice and thanks so much

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...

Your the best Denis

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

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

Nice!