|
|
|
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 Using select queries in case statements Posted by Luqman at 8/3/2003 11:08:04 PM I want to use the multiple case statements in following query instead of
select sub query, how can I do so?
Here is the query
Select
(case when acc_dtl='Y' then
(select sum(Acc_Amt) from Acc
where acc_code=B.acc_code)
else
(select sum(Acc_Amt) from Acc
where acc_code like B.acc_code+'....more >>
sproc output Posted by Hassan at 8/3/2003 8:41:17 PM I need to perform some SQL based upon the output of another system sproc.
So if the sproc returns 1 row, then i need to do something, if not then dont
do anything..
How can i write a TSQL for that such as
exec sprocA
if ( # of rows returned is 1 ) then print ' Go ahead '
else print ' No ...more >>
query job help Posted by Hassan at 8/3/2003 8:22:31 PM I need to execute a sproc in a SQL job based upon the status of another job
and have to do it this way as opposed to a new job step in one job itself
(long story)
So in short I need to kinda evaluate the sp_help_job for a particular job id
or name and look at the current_execution_status and if...more >>
Splitting string Posted by NotYetaNurd at 8/3/2003 5:54:36 PM Hi all,
Here is my requirement
Using SQL 7.0
StoredProcedure(paramenter1, Paremeter2)
//paramenter1 being the table name
//parameter 2 being comma seperated values
i wanted to split the values and add to the table
how do i go about any clues is greatly appriciated
thanks ...more >>
Passing Array as a parameter Posted by Kishor at 8/3/2003 3:42:56 PM Hi all,
How do I pass a array as a parameter to a stored procudure can I have a
sample??
TIA
Kishor
...more >>
build a unique column ? Posted by Polaris at 8/3/2003 1:44:49 PM Hi:
I have 2 tables:
Table1: has 3 columns: C1, C2 and C3. Column C1 has duplicated members.
Table2: has only 1 column: C1 and all members are unique.
I like to merge Table1's C1 into Table2's C1 and keep all members in
Table2's C1 column unique. Which will add unique members in Table1...more >>
Req: Best Books on SQL queries and how to right them Posted by michael at 8/3/2003 1:30:51 PM ...more >>
Linking to SQLDMO.dll bypassing COM Posted by dameatrius NO[at]SPAM hotmail.com at 8/3/2003 12:52:47 PM I am currently dealing with a strictly C# .NET project. Our design
requires absolutely NO COM registration. For one of the update
modules, sqldmo's ExecuteImmediate is perfect in terms of what it can
handle vs. what a Command object can (take one single script of DDL
that creates/alters tables/i...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Is there any property like Validation Text in MS Access in SQL Server 2000? Posted by Pornthep Akkho at 8/3/2003 7:39:36 AM In MS Access, there are 2 very usefull properties that DB
Designer can use to provide restriction to value entered
by user in a certain field.
MS Access 97 or above MS SQL Server 2000
1. Validation Rule - Constraint
2. Validation Text - - (none)
Suppo...more >>
Is there validation text (like MS Access) in SQL Server 2000? Posted by Pornthep Akkho at 8/3/2003 7:24:54 AM I know that SQL Server 2000 has constraint which Database
designer can put restriction to a certain field. In MS
Acess, there are validation rules (compare to MSSQL server
is Constratint) and Validation text ( non of MS SQL Server
2000 exists this properties.
If I have table TTABLE and fi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |