|
|
|
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 limiting query result based on AS clause Posted by Fabuloussites at 5/13/2006 6:42:01 PM can some point me to a sql statement that would perfrom the equivalent of the
following statement?
select Desc, (select count (*) from CART_Items where
fkItemCategoryID=CART_ItemCategories.pkItemCategoryID ) itemcount
from CART_ItemCategories
where itemcount >0
typical ouput
Desc ...more >>
Cross Tab report Posted by imtiaz at 5/13/2006 5:22:19 PM I have a table with data in the following format
user menu rights
----------------------
John Acc Yes
John Tran No
John Rpt Yes
Mark Acc No
Mark Tran Yes
Mark Rpt Yes
and i need to display it as below
user Acc Tran Rpt...more >>
SQL Server 2005 -- Internal Query Processor Error: The query processor could not produce a query plan Posted by michael at 5/13/2006 1:48:29 PM Hi all
I migrated a database from SQLServer 2000 (Standard edition) to
SQLServer 2005, standard, SP1, on Windows XP Prof, SP3
After migration I get the following error:
Server: Msg 8624, Level 16, State 1, Line 6
Internal Query Processor Error: The query processor could not produce a q...more >>
Help with Select statement Posted by rocky20 at 5/13/2006 1:06:58 PM I need help creating a select statement that will show users who have
attempted to fill out a form more than once and have not completed it
at least once.
Here is the basic table layout.
ID int PK
PersonID int
Completed bit
Date DateTime
The data looks like this
ID Person ID Comp...more >>
Problem with SP Posted by Rudy at 5/13/2006 12:09:01 PM Hello All!
CREATE PROCEDURE dbo.PlbetII (@UserID NvarChar(50),
@Wager Nvarchar(50))
AS
IF EXISTS (SELECT 1 FROM Bankroll WHERE UserID=@UserID)
begin
Update BankRoll
Set Wager = Wager + CAST(@Wager as Nvarchar)
where userID = @userID
return -1
end
ELSE
begin
Insert Bankroll (Wager) ...more >>
Best design for edit tracking? Posted by roy. NO[at]SPAM nderson NO[at]SPAM gm NO[at]SPAM il.com at 5/13/2006 8:30:37 AM Hey all,
This is a general question. Here's my scenario: We have a legacy
database. The core table within contains almost 4 million records in
SQL Server. Currently we have a web front end which allows uses to
search through the database for the information they need.
What the client wants is...more >>
DBCC DBREINDEX Help Posted by sudarshan selvaraja at 5/13/2006 5:45:01 AM DBCC DBREINDEX ('pubs.dbo.authors', UPKCL_auidind, 80)
when the above given command is executed i get the result as
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
instead of
Index (ID = 1) is being rebuilt.
Index (ID = 2) is being rebuilt...more >>
FFXiUnlocked Get Free Stuff Virtual Gaming Sales information and more Start Making Money Today Posted by Shawn.T.P NO[at]SPAM gmail.com at 5/13/2006 3:29:07 AM A Must View Website!!!
Http://www.FFXiUnlocked.com
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Business Intelligence Development Studio Posted by Jon Paal at 5/13/2006 12:08:18 AM I installed :
Business Intelligence Development Studio
I don't find the program listed anywhere.
How do I access the interface ?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |