|
|
|
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 August 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 31 Error Handling Posted by Roy Goldhammer at 3/27/2004 11:50:41 PM Hello there
I'm working with SQL Server 2000.
My application is Access 2000.
When i run sql store procedure from access it brings me the errors that done
in the store procedure
Now i started using Transaction on my store procedures and not all the error
raised in access.
Here is the...more >>
Erro on datatyp Text Posted by Guoqi Zheng at 3/27/2004 9:27:52 PM Dear Sir,
I have the following two tables for a forum.
tblTopic
TopicId
TopicContent
....
tblReply
ReplyId
TopicId
ReplyContent
I tried to create the following SQL, I need to return a count of ReplyId to
that statement.
SELECT tblTopic.TopicId, tblTopic....more >>
Can anyone please help me with this sql? Posted by Hyper X at 3/27/2004 8:00:05 PM Hey guys,
This is a very very simple problem... Can anyone please help me with
this sql?
I'm sure some of you would have come across this problem. I'm hitting
a wall here...
----------------------My select command Begin...--------------
Select User, Item, Price, Qty, (Price * Qty) as Tota...more >>
Variable Column Name (Conditional Sum)!! Posted by Fouad at 3/27/2004 6:12:01 PM Hello All,
I don't know if this is possible or not, sounds not to me but who knows..
I have a table that contains transactions, and each transaction has the
customer code and the amount. Simple so far?
I need to write a query to give me each customer with two totals, one is the
total for ...more >>
help on joins Posted by jerry at 3/27/2004 11:31:10 AM I need help on creating a join so i can use data from one table to another
Table 1 Named SDELIVER
wITH BPAADD_0, BPCINV_0, BPDADDLIG_0, BPDADDLIG_1, BPDADDLIG_2, BPDNAM_0, BPDCTY_0, BPDPOSCOD_
TABLE2: NAMED BPDLVCUS
WHICH HAS 2 COMMON UNIQUE COLUMNS WHICH ARE BPCNUM_0 (EQUALS BPCINV_0 IN FIRST ...more >>
xp_sendmail attachments using unc Posted by Joe Reiss at 3/27/2004 11:18:11 AM Hi All,
using: SQL Server 2000
I'm trying to sen an email with an attachment on a shared drive like this:
EXEC Master..xp_sendmail @recipients = 'medidata@frontiernet.net',
@copy_recipients = '',
@subject = 'EMS Email',
...more >>
Windows authentication Posted by Akz at 3/27/2004 8:41:07 AM I have SQL Server 2000 installed and listening on one machine and a Java program on a separate machine trying t
access a database on the SQL server machine. When I use a Windows domain user account to acces the Server, I get the login error, Reason, Not asscociate with a trusted connection error
...more >>
Temp TABLE Posted by Ramesh at 3/27/2004 8:30:50 AM Hi Alll
I need to create temp tables from my front end application running in
VB.Every user is required to have a login id to log in to the
aaplication.The name of the temp table should be prefixed with the user id
of the user who has currently logged into my application.I need to drop and
recr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Temp Tables. Posted by Ramesh at 3/27/2004 8:29:00 AM Hi Alll
I need to create temp tables from my front end application running in
VB.Every user is required to have a login id to log in to the
aaplication.The name of the temp table should be prefixed(names are
predefined) with the user id of the user who has currently logged into my
application.I...more >>
Index Problem? Posted by Kostas at 3/27/2004 7:09:50 AM Hello Experts,
"Little dumb one question :)"
I want to create an index for a field which is an
nvarchar with size 1000.
The index created but the following message appear:
Warning! The maximum key length is 900 bytes. The
index 'IX_DOY_Descr' has maximum length of 2000 bytes.
For s...more >>
How do I: Update/Insert from Table to Table - Advice Appreciated Posted by Russell Mangel at 3/27/2004 3:46:08 AM I want to insert/update MailItemsInfo's Table
I need to get TotalLength & MinimumDate data from MailItems table
1. sum(Length) in the MailItems, update/insert MailItemsInfo table
2. min(ItemDate) in MailItems, Update/Insert MailItemsInfo table
I am not sure how to accomplish this efficiently, ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |