|
|
|
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 31 Stored Proc Problem Pls Help!!! Posted by Katie at 12/2/2006 10:19:15 PM Hi
I have a store proc which creates a string
for example
declare @sql varchar(1000), @totalCount int
select @sql = " select @totalCount = count(*) from people where
peopleID = 2"
then the string gets executed
exec(@sql)
The problem i am having is that i want to access that variable
...more >>
I need help with a tricky sum query Posted by Big Daddy at 12/2/2006 9:31:24 PM I have a query I can't figure out. I have a table of patients, and a
table of charges (where there can be multiple charges for one patient).
The patients table has a column for Length of Stay (LOS). I want to
do a query, joining the two tables, where one column gives the total
sum of all the ...more >>
Help needed with Stored Procedure Posted by Steve Harp at 12/2/2006 9:39:22 AM Hi All,
I'm stumped writing a stored procedure. I have from 1 to 24 workers
processing material on a line. Each batch they process creates a
record in a QcData table with a unique batch sequence.
QcData table structure:
BatchSeq int,
IntEmpID int
TimeChecked datetime
QcScore int
QCID...more >>
Help with complex SP Posted by Jose at 12/2/2006 7:50:15 AM Hi All,
I hope you may be able to help me as I am having difficulty writing a
SP to allow the following functionality:
Find all the books that are within a certain distance of the user,
filtered by categories and keywords. (If no filtering values are passed
we want to return all books irres...more >>
Stored Procedure Transaction Posted by Bob at 12/2/2006 7:13:01 AM If I've got a stored procedure that has two UPDATEs in it, is it ever
possible that one of the UPDATEs will commit and the other won't?
If so, should I wrap the two UPDATEs in a BEGIN TRAN / COMMIT TRAN block?
Thanks
wBob...more >>
Connecting nodes and calculating paths Posted by Rippo at 12/2/2006 2:06:07 AM Hi
I posted a problem on news groups about 18 months ago and got a couple
of answers from David Portas and Joe Celko.
The problem was:-
I have an interesting problem where I need to calculate paths between
connecting nodes.
For example:-
Node 1 is connected to Node 2
Node 1 is connec...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |