|
|
|
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 Query Frustrations Posted by Arvin at 12/6/2003 11:55:47 PM hi guys,
i am having problems with the result i want to get from
my query.... my table defs is this.
Table1
------------
| id | activity |
1 2
2 2
3 5
4 6
5 2
Table2
------------------
| id | type | translation |
1 1 Nothing
2 2 Hang...more >>
ASP + SQL Server Posted by Victor at 12/6/2003 9:41:05 PM I`m using ASP with Microsoft SQL Server 2000
I want to make an application to
1. display all the databases (catalogs) on the web server
2. depending on the user`s selection, display the database schema of selected database.
******************
1. How can I get the database list on the server??...more >>
downloading newsgroups messagess.. Posted by I_AM_DON_AND_YOU? at 12/6/2003 7:50:05 PM I have configured my outlook express to download the sql server newsgroups
messages. Everything is ok. Could anyone tell me where do I set 'the total
number of messages to download'? Right now this is set to '1000' but I want
to download only 50 or something else. How should I do this? Tell me th...more >>
indexed view performance incongruency Posted by John A Grandy at 12/6/2003 6:37:55 PM i have a sql2k sp3 with identical configuration on two different machines
machine 1 : xp pro sp1, single cpu ~2ghz, 512mb ram
machine 2 : w2k advanced server sp4, dual cpu ~2ghz, 1gb ram
i have an indexed view in the database. the view contains computed columns
that are string manipulatio...more >>
Group consecutive days? Posted by Stijn Verrept at 12/6/2003 6:30:50 PM Is it possible to group this?
1 3 2003-09-01 00:00:00 1 0
2 3 2003-09-02 00:00:00 1 0
3 4 2003-09-03 00:00:00 1 0
4 4 2003-09-04 00:00:00 1 0
5 4 2003-09-18 00:00:00 1 0
6 4 2003-09-19 00:00:00 1 0
7 4 2003-09-20 00:00:00 1 0
8 4 2003-09-21 00:00:00 1 0
9 4 2003-09-22 00:00:00 1 0
10 4 2...more >>
Access DB en SQL server DB Posted by EMW at 12/6/2003 6:29:13 PM An Access database is limited to 2 Gbyte filesize.
Does a SQL server database have such a limitation as well?
Does it have limitations?
rg,
Eric
...more >>
Foreign Keys across databases Posted by Axel Dahmen at 12/6/2003 5:19:41 PM Hi,
is it just me or does MSSQL 2000 not support foreign keys across databases?
Sybase server does.. Am I doing something wrong?
TIA,
Axel Dahmen
...more >>
Query to get days of absence Posted by Stijn Verrept at 12/6/2003 3:39:32 PM Hi expert query builders ;)
I have this table which records all events (that can be: a person that comes
in: IO_ACID = 0) or that is absent (IO_ACID > 0) absence can be because of
multiple reasons: hospital, family, travel, ... It's also possible that
someone comes in, then if absent for 4 d...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Float to Varchar Posted by Ray at 12/6/2003 2:21:01 PM I have a situation where I need to import a phone number from 1
database to another. The source database is an Access 2k database and
stores the value as a Float datatype. The destination database is
MS-SQL7 and stores the value as Varchar(13). Additionally, the
destination database requires ...more >>
single quotes in openquery() Posted by GreggT at 12/6/2003 1:26:11 PM I am trying to submit this query using openquery(). The single quotes cause an error.
Select * From OpenQuery(TESTSRVR, 'select * from tab where tname = 'WORKORDER';')
...more >>
How to convert int ZIP code to char(5)? Posted by Larry Gibson at 12/6/2003 12:48:43 PM I know this has been answered before but I searched through nearly a months
worth of posts and can't find it. I just need to be able to convert a ZIP
code that was stored as an integer with leadingin 0's added to pad the field
to the correct length if the number is smaller than 10000. I tried
...more >>
using IF in ORDER BY Posted by shank at 12/6/2003 10:54:10 AM I cannot get the correct syntax for what I believe is pretty simple. It
pretty much speaks for itself. I'm getting a syntax error: "Incorrect syntax
near keyword ORDER". Can someone give me a clue?
thanks!
---------------------
SELECT...
WHERE...
IF @Column <> ''
ORDER BY
CASE @Column WHE...more >>
Problem With BOL Example Posted by Wayne Wengert at 12/6/2003 8:28:00 AM I am big time confused about "cursors" (another post later on that) so I
went to BOL and am trying to get a better understanding from info and
examples there. I came across the example below but when I try it in QA I
get the following errors: (BTW - can anyone explain the line numbers shown
in t...more >>
connection Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/6/2003 1:07:25 AM Please help me resolve I'm stuck and a novice
I have a connection string in a VB app that I am working
on but when i execute app I get
Run time Error -2147467259 (80004005) Login failed for
user *** reseaon not a trusted SQL Server connection.
I am set up on SQL server I can run enterprise ma...more >>
How to require AVG to return value with precision and scale? Posted by Dean Slindee at 12/6/2003 12:07:20 AM AVG(dbo.tblLSIInitial.scrIOffenses) AS AvgOfscrIOffenses
The above statement in a SQL Server procedure gives a result that is a whole
number, dropping any fractional part to the right of a decimal point. While
the statement below in an Access query (before upsizing) gives a result with
9 posi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |