Forum Replies Created
Viewing 15 posts - 3,046 through 3,060 (of 3,543 total)
-
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.
-
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
-
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...
-
RE: big bonus for answering on-the-day
Frank,
Falling On The Floor Laughing (FOTFL or FOFL)
Acronymmmmmmmssssssssss Agh!
-
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.
-
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...
-
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... -
RE: Aggregate and Top
select avg(discount) from (select top 5 discount from discounts) a
-
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
-
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... -
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 =...
-
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...
-
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...
-
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...
-
RE: importing text file with bad lines
I presume you are importing from a text file and delimiting by comma. If so DTS should ignore any columns in excess of the mapping and set null for any...
Viewing 15 posts - 3,046 through 3,060 (of 3,543 total)