|
|
|
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 Stored procedure always returns NULL in ADO.NET Posted by konnyro NO[at]SPAM yahoo.com at 11/6/2004 10:42:33 PM I have a simple stored procedure, it always returns NULL value,
but if I run it in the query anl. it'll work just fine.
Can't figure it out...
Any hint will be appreciated
Thanks,
Dean,
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[usp_GetTotalWeight]') and OBJEC...more >>
Counting values on row Posted by Mitch at 11/6/2004 8:19:20 PM Hello all.
I have a table like this:
ID COND1 COND2 V1 V2 V3 V4
all of type int
In V1 - V4 i have vlaues from 1 to 10
I want to have a result with one row in which i have how many 1's and how
many 2's ... are on the whole table
Another question: can i have in a SELECT statement a...more >>
Is Redundant Data Ok? Posted by Leon at 11/6/2004 5:30:33 PM I have two tables one name members and the other name winners. The members
table hold such information as FirstName, LastName, Email, etc., and the
winner table hold such information as FirstName, LastName, Email, Prize,
Address, City, etc. However, as you can see these two table holds pretty ...more >>
xp_sendmail send an individual a task to their Outlook Mailbox Posted by dave NO[at]SPAM att.com at 11/6/2004 3:56:53 PM Does anybody know how to send an email from SQL 7 to an outlook
mailbox that actually posts it as a task on the receivers in box.?
In my project managemnet app, I want to send a task to the individual
with a due date. Not sure what options that would include on the exec
xp_sendmail.
We're A...more >>
Newbie help emailing a blob field Posted by dave NO[at]SPAM att.com at 11/6/2004 3:09:15 PM I'm trying to write a simple program for a project managemnet
application that emails a message to the assigned people when the
status of an issue changes. I'm ok with generating the message nad
sendign it out, my problem is how to send the updated 'Comments'
field. The trigger will not let me...more >>
problem exectuing storded procedure Posted by Jan Schmidt at 11/6/2004 2:59:38 PM Hi NG,
I've got an ASP Script (useing Javascript) to which i send data to by POST.
This data stored in variables will be transferred to SQL stored Procedure.
As shown at bottom...
welches eine Variable übergeben
There is coming up an error...
I don't know how to solve it,
please help or giv...more >>
Synchronizing readers and writers... Posted by Pradeep Tapadiya at 11/6/2004 2:44:50 PM Hi,
In my scenario, a Web application reads data from a SQL Server database
while a page is being loaded. . Another application updates the database on
an hourly basis. At any time, there are at least 15 users browsing the web.
Considering the amount of data involved, the actual time to upda...more >>
Date and time design problems (advanced) Posted by Jonah Olsson at 11/6/2004 12:01:03 PM Hello,
I'm facing a problem with an event calendar. Assume that one "event day"
starts at 3 a.m. and ends at 3 a.m. the next day. I receive an XML file each
day containing current events, and I have to insert this data into an SQL
Server. Later on, I want to sort and filter the events by da...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
min memory per query Posted by Peter Zentner at 11/6/2004 11:58:55 AM I have a VB.NET application which reads thousands of records from a MSDE
Database, processes them, and writes them against a MYSQL Database. I'm
using the MySQL .NET DataProvider for accessing the MYSQL Database. When I
test the application on my lap top (512MB RAM; MSDE Memory limited to 260MB)
...more >>
UNION / DISTINCT error message? Posted by Rob Meade at 11/6/2004 10:25:20 AM Hi all,
I recently solved a problem by using the UNION statement to join 3 queries
together giving me a recordset I could use in my application:
SELECT '1' AS AllocatedOrder, a.KBAID, a.KBAName, a.KBGID, b.KBGName,
b.KBGDisplayOrder, b.KBID, c.KBName
FROM tblKnowledgeBaseArticle...more >>
How do u SELECT this one? SELECT rank=count(*) Posted by mekim at 11/6/2004 9:44:01 AM Hi All,
Hmmm...I give up :-) I'm trying to get the following to work
i.e. in the KB article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133
select rank=count(*), s1.title_id, qty=sum(s1.qty)
from (select title_id, qty=sum(qty) from sales group by title_id) s1,
...more >>
How to get the old value while on an update trigger? Posted by Willianto at 11/6/2004 1:41:16 AM Hiya guys!
I have an update trigger on, let's say table1, in which I need to make a
conditional based on one column in the old table1 itself. Does anybody
knows how to refer to _that_ column value?
TIA,
Willianto
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |