Recent content by itprsn

I'll check out BCP, thanks.

1. Yes, the results are saved and used in other programs that error out with the blank lines if they're not removed. 3. I didn't see any check boxes for this either.

In SQL Server Management Studio Express: when running queries and sending the results to txt I get blank lines (or returns?) at the end of the results. Does anyone know where these blank lines are coming from and how to stop them?? Thanks...

I'm using Crystal 8.5, having difficulty pulling XML data in. How can I tell what the table and row hints should be to pull the data in (assuming that's the problem)? I'm connecting and getting the following fields but no other: <lastauthor>, <created> and <version>. I get no other fields and...

I'm not sure I set up/ran the procedure correctly, it didn't appear to do anything... It appears this is related to blank lines. When selecting my data I selected columns, not specific rows/columns. I really do need (I think) just columns because the number of rows is variable - but I want...

My data is as follows: 7/9/2008 12:44:32 AM. I need to use the number option in pivottable field (lower right) to format this field as the time alone - but I don't have access to the number button - ??

Thanks, I will check it out!

Thanks everyone for your help! Following the advise to look at the convert function (in particular the style argument), I came across the following info: http://databases.aspfaq.com/database/what-are-the-valid-styles-for-converting-datetime-to-string.html

Yes, I found it, thanks (newbie)...

BOL??

I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. I need the correct syntax to select just the time in this field. Can anyone help? Thanks...

I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. Need the correct syntax in SQL to pull out just the date. Can anybody help? Thanks...

Apparently so - 1000.0000 worked. Thanks!

Having no luck trying to get precision 2 data in a stored procedure. I've tried variations of the following logic with no success. Can someone help? Thanks... SELECT CONVERT(DECIMAL(10,2),SUM(PRD.Pages*GrossFolder)/1000) MGP FROM...

Got it, adding an adjacent column in the data source was new to me but I understand where you're going with this now... Thanks for your help!!