Try an add the S paramter for the SQL Server.

Mine worked with

OSQL /i c:\xml.sql /o aa.xml -SLENE -E -w10000

Using proportional of fixed spaced fonts when displaying the text files

Maybe try Courier, even in Notepad.exe

Agree EXISTS is supposedly to be faster!

I just return '1' versus (* or a column).

If Exists (Select '1' from Table where Col = @xxx)

Update

Else

Insert

http://www.15seconds.com/issue/011106.htm

There is a better example of reading SQL batches from files and applying through OSQL, using the vbscript / FileSystemObject. Cannot find it!. Will have a look again over the...

Another try at a solution!

Declare @start DateTime,@end DateTime, @month DateTime

Set @month='2 jan 2002'

Set @start= Convert(Char(8),@Month,120)+'1'

Set @end= DateAdd(ms,-3,DateAdd(m,1,@start))

Select Convert(char(11),EventDate,106),Count(*)

From MyTable

Where EventDate Between @start and @end

Group by Convert(char(11),EventDate,106)

Order by Convert(char(11),EventDate,106)

Try and add...

Also using the route / method RonKyle is refering to.

INSERT INTO RMAItems

(item_num, order_num, line_item_num, item_desc, ship_to, vend_num, numToReplace, F3RMANum,

vend_bill_to, product_num, unit_price_billed, cost_atbill)

VALUES ( 231367, 27690, 4, 'SSSI-3/SCSI-3 CABLE MICRO DB68M - 6" W/T''S', 14800, 652, 1, 2654,...

BOL 2000 :

There are no separate time and date data types for storing only times or only dates. If only a time is specified when setting a datetime or smalldatetime...

Can you post a small example

I try limit apply the filter as close to the source of the data as possible. Example in the ON clause rather...

Check for recompiles on sp.

"We" always drop temp tables explicitly.

If it is recompiles have a look at http://www.databasejournal.com/features/mssql/article.php/2218451

Declare @d Datetime

Set dateformat mdy

Select @d='7/29/2003 8:02:22 AM '

Select @d

SELECT SUBSTRING(replace(replace(replace(convert(varchar,@d,120),'-',''),' ',''),':',''),1,14)

...

JPipes and Scott Coleman excellent discussion. Similar problems with a web app but with lots of summations and filters.

Just for interest sake from BOL 2000 :

DECIMAL AND NUMERIC

PrecisionStorage bytes

1 - 95

10-199

20-2813

29-3817

FLOAT AND REAL

n isPrecisionStorage size

1-247 digits4 bytes

25-5315 digits8 bytes

Only use cursors as a last resort.

Sorry, I misread the SQL statement