|
|
|
January 2003 March 2003 April 2003 May 2003 June 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Executing a stored proc from PowerBuilder 6.0 Posted by Shibu Shaji at 11/9/2003 11:40:03 PM Hi,
I am executing a stored proc. from PowerBuilder and
receiving the following error message:
Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This
ensures consistent query semantics. Enable these options
and then reissue your query....more >>
excel like statistics Posted by marwan hefnawy at 11/9/2003 10:51:28 PM Suppose we have two tables, col_age in table1 represens the age in years,
and col_bin in table 2 represents some age groups (0,5,15,32,60,72) say.
How can I tell how many records in table1.col_age has values between 0 and
5, and how many ages are between 5 and 15, and so on (according to the
val...more >>
query question Posted by marwan hefnawy at 11/9/2003 10:49:54 PM suppose i have a table with two columns
col1 has numerical values and col2 is the month in which this value occur.
ex:
col1 col2
50 Jan 2003
70 Feb 2003
90 Mar2003
62 Apr 2003
73 May 2003
40 Jun 2003
61 Jul 2003
100 Aug 2003
90 Sep 2003
55 Oct 2003
I ...more >>
avoid putting logic inside of stored procedure? No IF ??? Posted by Hazzard at 11/9/2003 8:06:07 PM I recently saw a coding standard which says to avoid putting any logic
inside of a stored procedure.
It also says that if there is an "IF" inside of a stored procedure you are
doing something wrong.
Why is this?
Thanks,
-Greg
...more >>
Charindex problem Posted by Ben at 11/9/2003 5:08:58 PM Hi group-
I'm having a problem with CHARINDEX returning unexpected results. SQL 7,
default code pages, installation etc.
Due to the DB design (or lack of) inherited from my four-fathers and
eight mothers, I need to work through some data proceduraly in my SP.
The data I am working with has p...more >>
Better Way To Do This? Posted by Wayne Wengert at 11/9/2003 2:16:41 PM I have one table (teams) that has a TeamID field (PK) and other information
related to the team and a table (events) with an EventID (PK) and
information about the event. I have another table (signups) with a record ID
(PK) and also the following fields:
TeamID, int
DateSignedUp datetime
A...more >>
Bug in SQL Server ? Posted by hwoess at 11/9/2003 1:35:41 PM Hi,
i am using MSDE 2000 with sp3a and just want to know
if this is a defined behavior or a bug:
create a table with a field, let's say, id, from type integer.
Insert record with id = 0, insert another one with id = 1.
Then do a:
select * from testTable where id > ''
.... shows only rec...more >>
How to force sql server to use "index seek" instead of "index scan"? Posted by dc NO[at]SPAM upsize.de at 11/9/2003 1:05:16 PM Hi,
I am using a LIKE query on a clustered index with about 1 mio. rows:
declare @term varchar(63)
set @term = 'searchthis%'
select * from terms where term = @term
The execution plan shows an index scan for this and the query takes
about 5 second.
When I execute this:
select * fr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Update SQL question Posted by jdwagman NO[at]SPAM earthlink.net at 11/9/2003 12:28:00 PM I have a table x which is like (amt double not null
relation_id integer not null
tranche_id integer not null).
Amt,relation_id and tranche_id was populated by fields
inv_amt,relation_id and tranche_id from the INV table. I'd like to...more >>
Raise Error Posted by Jeff Haumesser at 11/9/2003 12:21:14 PM I was wondering if you could help me out.
I have a stored procedure that inserts a record into a table. In this
stored procedure, i check to see if a record already exists for the criteria
passed in. This record in not based on the key field. If it does, I would
like to raise an error to tra...more >>
traversing through a Hierarchy Posted by exBK at 11/9/2003 11:51:05 AM Hi,
I have a table that contains parent-child records. Is there a simpler way to travers through each parent ?
i.e, lets say I have 5 employees under a manager, when I start with the first employee, how do I move to next employee ?
this is how my data looks:
parent_id emp_id name s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |