|
|
|
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 Side Clash in distributed transaction Statement Posted by Bishoy George at 8/19/2006 11:27:18 PM Hi,
I have a distributed transaction statement that updates an SQL server
instance on Windows Server 2003 from another SQL server instance on Windows
XP SP2.
Both servers a linked to each other.
The DB is the same on server and client.
I use SQL Server 2000 with SP3 on both server and ...more >>
WHERE Clause CASE Posted by Scott at 8/19/2006 6:34:27 PM The below WHERE clause in CODE 1 works fine, but gives me a null error if
mill_id = 2. That's because the WHERE clause should look CODE 2 when mill_id
= 2.
Is there a way to use the CASE function in the WHERE clause to test the
mill_id variable and use "AND time_run2 IS NOT NULL" if mill_id...more >>
Fill table with dates based on a source date columns Posted by robc390 NO[at]SPAM hotmail.com at 8/19/2006 5:19:52 PM I am trying to build a lookup table of valid dates for given business
periods of time.
Given four peices of information:
PERIOD, START_DT, MID_DT, END_DT
I wish to have one row for each date between START_DT, and END_DT for
the PERIOD.
Also, I wish to know the days between START_DT, MID_DT.
...more >>
delete query Posted by tom taol at 8/19/2006 3:12:21 PM
table1
fld1
aa
bb
cc
table2
fld1
aa
cc
after query execute
result table1
table1
fld1
bb
"delete from table1 a where a.fld1=table2.fld1"
but not working
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Could not find Type 'StoredProcedures' in assembly 'HelloWorld' Posted by carl.jung NO[at]SPAM hotmail.com at 8/19/2006 11:54:47 AM Hi,
I am trying to create a CLR stored Procedure as bellow:
create procedure HelloWorldSP
as
external name Helloworld.StoredProcedures.HelloWorldStoredProcedure1
However I get the error:
Could not find Type 'StoredProcedures' in assembly 'HelloWorld'
My .NET code to create the managed...more >>
Fill table with dates based on a source date columns Posted by robc390 NO[at]SPAM hotmail.com at 8/19/2006 11:14:33 AM I am trying to build a lookup table of valid dates for given business
periods of time.
Given four peices of information:
PERIOD, START_DT, MID_DT, END_DT
I wish to have one row for each date between START_DT, and END_DT for
the PERIOD.
Also, I wish to know the days between START_DT, MID_DT.
...more >>
newbie: how to access variables across multiple queries Posted by groups NO[at]SPAM jhodes.fastmail.fm at 8/19/2006 9:37:38 AM Hi All,
I've inherited a bare-bones reporting environment that relies on
manually executing dozens of select queries in Query Analyzer each
month, then cutting and pasting results into Excel. Each month, the
date ranges for each query have to be manually adjusted.
I know there are much more...more >>
optmizing Cursors Posted by hch at 8/19/2006 3:12:01 AM Hi all
I m working on a stored procedure with 5 nested cursors working on 5
temporary tables . I tried some technics to reduce the response time but i
didnt succed
I tested these methods :
- Replacing cursor by a while loop
- calling form the cursor a User defined fuction
-replacing tem...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |