That's proof that when a dba/dba developer needs answers, where do they go? SQLServerCentral.

Congratulations!

I'm not sold on hydrogen either, looks good on paper but still an energy hog to produce.

Actually, here in the US, hydrogen is generated from natural gas, so it's still...

I'm still up in the air about all this hybrid stuff...

I was at a dealer for car inspection and there was a Prius idling in the parking lot for over...

...is there an issue with the "except" operator?

select top 40 * from table_name

except

select top 39 * from table_name order by column_name desc

The source query for me is sorting Asc,...

Interesting about the Fair Labor Standards Act. I haven't heard of any companies that "refund" your vacation if you've got to dial in via laptop or work via phone while...

Yes, the stored proc passes a Y or N to set the visibility of the rectangle.

As far as counting detail lines, I create a temp table using my final recordset...

You can do this but you'll have to resort to using a cursor in your stored proc that feeds the report.

I had to do something similar in a statement where...

I had a similar problem with blank pages or page breaks cutting up detail lines. I worked with Microsoft on this and another problem. They had no answer for the...

SQL Server Central is a very good resource for not only SQL troubleshooting, but as a place to share your own knowledge.

I also identify with Steve's editorials, since I am...

I'm not sure if you were able to find a solution yet, but if the problem is intermittent it may be that the source file is open and locked by...

I had a similar situation where the user community required a complete detail section to show on a page without bleeding to the next page. My detail lines range from 1 to 5...

No we're not having a problem with ram while it's running.

I was able to reproduce this problem over and over again. I narrowed the recordset down to a particular agency and...

To quickly see what's going on you could use a query like this from query analyzer on one of the databases in question...check to see if there are any stored procs...

Another alternative to consider is that you could also use openrowset to get just the one column...

..if your comma delimited file looks like this

col1,col2,col3,col4

1,2,3,4

5,6,7,8

9,10,11,12

you would select this..

select col1 FROM OPENROWSET('MSDASQL',...

Sorry Himabindu,

this is off the subject but, Hawg's binary caught my attention...I'm sure many have done the same thing...pretty slick

string   value           

-------- ----------- ----

01010011 83          S

01010001 81          Q

01001100...