Forum Replies Created
Viewing 15 posts - 3,046 through 3,060 (of 3,544 total)
-
RE: requirements for a development web server
IIS 5.0 comes with Windows 2000 and .NET Framework is downloadable from Microsoft (see http://msdn.microsoft.com/netframework/downloads/howtoget.aspx )
Edited by - davidburrows on 09/22/2003 07:07:00 AM
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Averaging Top 3
Jonathan,
Don't you mean
ORDER BY Test DESC
Your solution works because the marks are in ascending order with Test.
Far away is close at hand in the images of elsewhere.
Anon. -
RE: How to run Profiler from another server in 7.0
What SP are you on?
If you are on SP3 and have registered more than one SQL Server then refer to
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Language & Date format
You found the same as I did. I think it is a quirk of sql. I did the following tests, the first value is what I set a datetime...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: big bonus for answering on-the-day
Frank,
Falling On The Floor Laughing (FOTFL or FOFL)
Acronymmmmmmmssssssssss Agh!
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Exporting to a text file from a stored procedure
Barry,
It's to do with concatenation. When you put text between quotes on separate lines sql will include CR/LF in the text. Sometimes it is useful sometimes not.
Far away is close at hand in the images of elsewhere.
Anon. -
RE: big bonus for answering on-the-day
quote:
An I having a deja vu event?This discussion has been lead?!? before
Swings and roundabouts...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: big bonus for answering on-the-day
quote:
Why should it be harsh, David? If you can't answer the question in time, well, then you don't answer it... or receive...Far away is close at hand in the images of elsewhere.
Anon. -
RE: Aggregate and Top
select avg(discount) from (select top 5 discount from discounts) a
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Exporting to a text file from a stored procedure
Depending on your definition of 'query' you could use bcp
exec master..xp_cmdshell 'bcp "select ... from datbase..table"
queryout outputfilename
-c -Sserver -Uuser -Ppassword'
or
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Complex Query: Please HELP!!!!
CREATE TABLE #A(ID1 int,ID2 INT,
RowID nvarchar(15),
Created Datetime,CreatedBy nvarchar(25),
Field nvarchar(25),
OldValue nvarchar(25),NewValue nvarchar(25))
INSERT INTO #A
SELECT 0,0,RowID,Created,CreatedBy,Field,OldValue,NewValue
FROM AuditTbl
ORDER BY RowID,Created,Field
DECLARE...Far away is close at hand in the images of elsewhere.
Anon. -
RE: importing text file with bad lines
Depending on what software you are going to use. Here is vbscript code that will count the number of commas in each line.
Const ForReading =...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: importing text file with bad lines
You could use a hex editor if you have one. It would also find out if the file contains any 0x00 characters. Normally in these situations I'd write a one...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: importing text file with bad lines
Check the data file, if you have copied an iis log file (which your data looks like) that is still being used by iis then the file will have approx...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Incorrect Syntax
Which scripts do you mean, from the scripts section or from posts. If you are copying and pasting from posts you have to check the formatting, not all code will...
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 3,046 through 3,060 (of 3,544 total)