Programming SQL

select/isolate group from... where max(date in group) = someda
seems you're making it harder than you have to. There's no need for a group by or Max() funciont. SELECT Code FROM #Tmpa WHERE CodeDate = '20081231' "Rich" wrote: Never mind. I figured it out: select code from #tmpa GROUP BY code HAVING max(codedate) = '12/31/08' I just didn't have... 7 Jul 2008 13:32

select/isolate group from... where max(date in group) = somedate?
In the following data I need to select (or isolate) the codes (code groups) which contain a max codeDate of '12/31/08'. Of the codes a, b, c, d -- only codes b and c contain a max codeDate of '12/31/08' in their respective groups. What would be the tsql to isolate these 2 codes (groups)? create table #tmpA ... 7 Jul 2008 12:30

Browser error - analysis services tutorial
The problem may be caused by the registered servers(above one,i.s. at least two) in SQL Server 2005 Group. Solution: Open the analysis services tutorial,click project menu->analysis services tutorial attribute->development,then input the RIGHT registration server name in the column. The error is caused by t... 7 Jul 2008 11:28

Change Service Account Password
Hi, I need a simple SQL-DMO or WMI code to change SQL Services account password on SQL 2000 and SQL 2005 servers. Thanks for your help. ... 7 Jul 2008 12:30

Highest and lowest values
Hi, MY input values Low Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be HIGH. High Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be LOW. create table temp(time datetime,[close] money) insert into temp values('11:20','40... 7 Jul 2008 08:23

Highest and lowest values
Hi, MY input values Low Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be HIGH. High Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be LOW. create table temp(time datetime,[close] money) insert into temp values('11:20','40... 8 Jul 2008 04:54

Issues and tissues in sql
If you're a student of sql I think you'll find two recent threads very interesting. microsoft.public.sqlserver.programming Thursday, June 26, 2008 'update joined tables' http://tinyurl.com/69hh5c microsoft.public.sqlserver.programming Sunday, June 29, 2008 'Storing a collection of lines' http://tinyurl.co... 7 Jul 2008 06:21

Invitation to critique a unique stored procedure
This is written against a legecy database. involves hierarchy Inputs come from a web page Output is a table for a report I am looking for... .. the identification of errors in approach .. suggetions for simpler or better approaches thanks, Doug //////// start ////////////////////// USE [NCT] GO /***... 9 Jul 2008 19:54

'Invalid object name' for temp table when executing a SP
I am getting the message 'Invalid object name' when I am attempting to execute a stored procedure in which there is a temporary table. The message reads: "There is an error in the query. Invalid object name '#UsersEntities'." I do not receive this error when I execute the stored procedure from the query win... 10 Jul 2008 19:37

Need help!
Hi All I have a table, Orders table, that has a values for its comments field like e.g 01/02/01: My text with a leading space 01/02/01:My text with no leading space. I want to write a sql statement, that gets rid of the space after the :, so that it would look something like this, because I need only ... 7 Jul 2008 05:19