This solution has worked well for me on an MS SQL 2005 Standard Edition 64 bit.

I am using the spSQL2PDF_2 version as illustrated in a previous reply.

It is...

It look like you need either col1,col2,col3 to all equal the parameters or where

any one of col1,col2,col3 is null.

To avoid using OR, perhaps try union as such:

--//

select col1,col2,col3 from [dbo.]...

Thank you. I didn't think this could be done but wasn't sure. Thanks for clarifying it for me. Grady Christie.

I ran across this Object Finder add-in for SSMS some time ago. It seems works well.

Hope it helps. Regards, Grady Christie

For vb.net I've used something like this in the past. It has worked well. Hope it helps. Grady Christie

'//

Public Sub DataTableToExcel(ByVal dt As DataTable)

...

if you need to display the number of records try this:

SELECT memberID,

count(*) as occurs

FROM memberResponses

WHERE responseID IN

(

1,3,4,6,8,15

)

GROUP BY memberID

ORDER BY occurs DESC

Hope it helps. Grady Christie

That works perfectly!

Many Thanks, Grady Christie

I have a function that I use to pad with zeros that works well;

--//

create function [dbo].[fn_PadWithZeros]

(@val decimal(18,2), @len int)

returns varchar(100)

as

begin

declare @cval varchar(4000), @i int

set @i=isnumeric(@val)

if...

I've had trouble with format files in the past. Sometimes if you will place a newline on the last column that will do the trick.

9.0

2

1 SQLCHAR 0 100 ";"...