|
|
|
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 Stored procedure Posted by Hello,
I have the below SP that is running very slow, can any one Help please.
Thanks!
----------------------
CREATE PROCEDURE dbo.C1_ProcessChangeQueueItem
(
@ErrNo INT OUTPUT
, @ErrMsg NVARCHAR(510) OUTPUT
, @RowsAffected INT OUTPUT
, @Queue...more >>
Sql Server 2000 GOTO statement Posted by Dave Sexton at 3/17/2007 10:27:20 PM Hi,
I'm hoping someone can verify whether the following T-SQL batch is valid in
Sql Server 2000:
IF 1 = 1
GOTO TEST
RETURN
TEST:
SELECT 'Tested!'
The expected result is:
Tested!
Thanks :)
--
Dave Sexton
http://davesexton.com/blog
http://w...more >>
SQL Select Posted by Aleks at 3/17/2007 8:59:50 PM Hi,
I have a simple select like
Select ID from table
it returns something like:
1
2
3
4
I need it to return something like
Select ID as groupid from table
where the result is
groupid
1,2,3,4
Does this makes sense ?
Aleks
...more >>
I need someone elses eyes on this Posted by Mike Labosh at 3/17/2007 8:22:24 PM CREATE TABLE dbo.Orders (
OrderID INT NOT NULL IDENTITY(1, 1)
CONSTRAINT OrdersPK PRIMARY KEY CLUSTERED,
CustomerID INT NOT NULL
-- CONSTRAINT CustomersOrdersFK
-- REFERENCES Customers (CustomerID),
EmployeeID INT NOT NULL
-- CONSTRAINT EmployeesOrdersFK
-- REFERENCES Emplo...more >>
view with distinct x subquery Posted by Marco at 3/17/2007 10:34:02 AM I’ve a doubt about using a view with DISTINCT or using a subquery in a query.
It’s not easy to explain so I will try using the Pubs database as an example.
Let’s says I have a query and now I need do add the Store’s name of a sale.
I just have the order number and if I look to the Sa...more >>
script lost: converting a table to a delimited list... Posted by Jeje at 3/17/2007 10:04:18 AM Hi,
I have read an article in the past which convert a table result to a
delimited list.
I remember the usage of the XML data type and functions to do this.
but I have lost this article...
Anybody can point me on it?
or maybe share a sample 1 pass select statement to do this?
thanks....more >>
Generate SQL Script Posted by Mehdi at 3/17/2007 3:49:03 AM Hi everybody
I want to generate SQL script from my Stored Procedures. with the console of
microsoft sql server I can do it. but I want to do it with 'WITH ENCRYPTION'
tag.
Is there any tools to do it with wizard?
Thanks
Mehdi...more >>
HOW_LINKED_DbASE_FOLDER_TO_SQL_2005_64_BIT=3F_PLEASE_HELP_ME!!!!!!!_Wi=EAcej_opcji Posted by gramir NO[at]SPAM lanet.wroc.net at 3/17/2007 2:33:52 AM I HAVE SQL2005 32 BIT ( TEST) AND SECOND MACHINE SQL2005 64 BIt
(PRODUCTION).
IN SQL2005 32 BIT I LINKED SUCCESFULL DBASE FOLDER (FILES CLIPPER)
BY
OPENROWSET BY:
select * from OPENROWSET('MSDASQL',
'Driver={Microsoft dBase Driver};SourceDB=c:\MyApp\;SourceType=dbf',
'select * from MyT...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |