|
|
|
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 Instead of SELECT TOP 10 - SELECT Range 0-10 or 20-30 and so on? Posted by Marco Napoli at 11/5/2006 11:08:43 PM I am trying to use a SELECT statment to return a range of rows like the
SELECT TOP does but instead I need it to be a range like 0 to10 or 20 to 30
and so on.
Any ideas?
--
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org
...more >>
identity column Posted by vanitha at 11/5/2006 10:13:01 PM hi,
i create a temporary table with a identity column. i am getting the
following error
An explicit value for the identity column in table '#tmp' can only be
specified when a column list is used and IDENTITY_INSERT is ON.
i have included the statement
SET IDENTITY_INSERT #Tmp ON
...more >>
convert varchar to datetime Posted by vanitha at 11/5/2006 9:56:03 PM hi,
i want to convert varchar to datetime
example
i want the first date of the month.
convert(datetime,'01-'+month(getdate())+'-'+year(getdate()))
its not working for me.
pls do help me solve this.
thank you
vanitha...more >>
Slow on Server but fast on local pc Posted by mike at 11/5/2006 9:10:49 PM I'm running a script with a cursor; appending, updating inserting rows in
multiple tables. on my local pc it takes about 3 minutes in sql server 2005
Query screen. It takes 20minutes on the server. The database is in 2005
converted to from 7.0 to 8.0. on the server it's converted from 7.0 to 9.0....more >>
2 digits in DAY? Posted by Per W. at 11/5/2006 8:52:50 PM hi, how can i make that when SET @TD_Day = DAY(@rightnow) is 5 then the
result is 05 in a easy way?
/Per W.
...more >>
Using a datetime value in a select by group by the month Posted by Aussie Rules at 11/5/2006 8:31:20 PM Hi,
I have a table with sales data, and each transaction is dated, into a
datetime field that is populated with the time of sale.
What I want to do though is group all sales for reporting, but where I show
the total for by months.
How do i select all sales say in January even though its...more >>
Newbie, construct an email message help Posted by verci at 11/5/2006 7:29:32 PM hi guys, i think this is another stupid question :( , thanks in
advanced.
I'm running SQL Server2000, is there a way to assign the result of a select
query that returns 3 fields to a varible I use to construct the body of an
email message? this because we don't want to create a variable...more >>
SQL Server 2000 Posted by NC Beach Bum at 11/5/2006 7:10:02 PM What is the max number of processors that SQL 2000 Standard supports?
--
NC Beach Bum...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Joining two sets of INNER JOINs with an OUTER JOIN Posted by --Hojo-- at 11/5/2006 6:47:27 PM Hello All:
I've been searching Google Groups for some time now and the SQL/Access
wisdom found herein has saved my life (so to speak) on many occasions.
I particulary enjoy reading posts by Celko and Erland, the "gods of
SQL".
I just went through a few days and nights trying to make the c...more >>
Help with Select Posted by Esha at 11/5/2006 4:14:37 PM I don't know if it's possible at all.
I need to display some data in VB6 application in Graph control.
To make my question simpler:
I have a table Orders with data like this:
Salesman SellingPrice Profit OrderDate
----------------------------------------------
First ...more >>
Create Partition Function incorrect Syntax Posted by HawleyBeach at 11/5/2006 2:41:01 PM I have just upgraded SQL Server 2000 to SQL Server 2005 Enterprise. I got an
error "Incorrect syntax near 'Partition'" running query below:
CREATE PARTITION FUNCTION PFORDERS (SMALLDATETIME)
AS RANGE LEFT FOR VALUES (GETDATE() - 30)
Also, PARTITION is not highlighted as reserved like CREATE doe...more >>
Continous running processes is it a bug? Posted by Sammy at 11/5/2006 5:00:01 AM We have a third party app designed in access it uses a form that has a
dropdown box selecting one column from a Sql Server 2000 table its connected
to sql server using odbc. When scroled down halfway for instance if a user
leaves the form in that state without selecting anything a running proc...more >>
Permission problem with a SP in which running sqlexecute Posted by Hayatbakhsh at 11/5/2006 12:21:02 AM Hi All
I have a stored procedure that I used a sqlexecute command in it and I used
some select command on some tables in sqlexecute command.
When I grant EXECUTE permission on this SP to a user, he can execute SP but
SQL server make an error that user does not have permission to run select...more >>
Getting back set order from the IN param Posted by Yobbo at 11/5/2006 12:00:00 AM Hi All
My query is as follows:
SELECT STRINGTEXT, TOKENID
FROM WEBSTRINGS
WHERE TOKENID IN (6,20,234,19,32,4,800,177)
All I want is my resultset to come back in the order that I have defined in
the IN clause, but unfortunately SQL is trying to be too helpful and sorts
the numbers in the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |