| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Select / Group By First Word in Column Posted by harrys NO[at]SPAM gmail.com at 6/14/2006 7:38:28 AM Hi,
Could anyone tell me if this is possible:
If i have a table like follows:
Col1
John Smith
John Jones
Ann Smith
Ann Thoms
John Peters
I want a query to group by the first name, so is there anyway to select
the first word and then group by it.
ie: My desired result is:
First ...more >>
Is this a SQL server BUG? Posted by mail2lei NO[at]SPAM gmail.com at 6/13/2006 11:28:23 PM I ran the following code on SQL server 2005 (SP1) to output deleted
rows to a table,
CREATE TABLE dbo.test(dateKey int)
go
declare @tt table ( datekey int)
insert into @tt values(1)
delete @tt output deleted.dateKey into test(dateKey)
go
But I received the following assertion error.
...more >>
A floating point exception occurred in the user process - Msg 3628 Posted by maidonical NO[at]SPAM gmail.com at 6/12/2006 3:49:36 PM I am trying to run "select * from <table> where <columnname> = 0.0" in
query analyzer
<columnname> is a float
I get the following error:
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current
transaction is canceled.
I get the same er...more >>
stored proc cannot be found err msg Posted by Dica at 6/12/2006 1:36:07 PM most of my stored procs can be called okay by my asp pages, but i keep
getting an error about one of them not being found, but it's there. the only
thing suspicious is that the majority of the stored procs were created via a
database restore on this server. the one that's crapping out was created...more >>
Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure Posted by news.sbcglobal.net at 6/11/2006 12:31:36 AM Here's my problem:
I'm developing an ASP.NET 2.0 application that has a user select one or more
auto manufacturers from a listbox ("lstMakes"). Once they do this, another
listbox ("lstModels") should be filled with all matching models made by the
selected manufacturers. If lstMakes was not m...more >>
SQL 2005 Mirroring Problems, HELP Posted by foren NO[at]SPAM wollweber.org at 6/10/2006 5:23:06 AM I try to Mirror a Database, i get the following Exception:
The server network address "TCP://xxx.xxxx.xxx:5022" can not be reached
or does not exist. Check the network address name and that the ports
for the local and remote endpoints are operational. (.Net SqlClient
Data Provider)
I can re...more >>
Running MS SQL query from Excel VBA Posted by excel_hari NO[at]SPAM yahoo.com at 6/8/2006 11:14:33 AM Hi,
(MS Sql 2005 and Office 2003)
I have a MS SQL query file which generates 8 outputs. I want to be able
to run this query from excel VBA and channel the 8 outputs to different
worksheets of a particular workbook. These are the things I want to
know:-
a) How to connect to the Database f...more >>
Cursor, last value twice... Posted by Zamdrist at 6/8/2006 10:16:31 AM Pardon my wrapping...I'm trying to figure out why this procedre returns
the last value twice, and how I can stop it from doing that...ideas?
Thanks.
Create Procedure MG_EcolabReport As
Declare @sColumnName As Varchar(40)
Drop Table tblEcolabReport
Create Table tblEcolabReport (fldMatter ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |