I would think that a search ends quicker when you find what you are looking for (EXISTS) rather than searching the entire table to declare that something is not there...

So it looks like this?

"FirstName" <Tab> "LastName"<Tab>"CompanyName"<CR>

"John"<Tab>"Doe"<CR>

"ACME"<CR>

"John"<Tab>"Doe"<Tab>"ACME"<CR>

"John"<Tab>"Doe"<Tab>"ACME"<CR>

"John"<Tab>"Doe"<Tab>"ACME"<CR>

"John"<Tab>"Doe"<Tab>"ACME"<CR>

"John"<Tab>"Doe"<Tab>"ACME"<CR>

Is there more than one row of data so it looks like this?

"FirstName" <Tab> "LastName"<Tab>"CompanyName"

"John"<Tab>"Doe"<CR>

"ACME"<CR>

"John"<Tab>"Doe"<CR>

"ACME"<CR>

If you run into an issue post the rest of your code.  I believe that, like all things, cursors in moderation are ok.

you can use dynamix sql

declare @sql varchar(8000)

set @sql = 'Select * from table1 where field1 in (' + @param1 + ')'

exec (@sql)

when you pass your parameter string you will need...

Here is a thread where Lowell wrote some code to decipher which bits are set.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=326235

Also according to Jeff 12 would be simple and you have it as full.  I think you will find that there are a number of other possibilities where both 4...

I don't think you accounted for autoshrink being set.

I believe it is status in master.dbo.sysdatabases.  I don't know the definitions of the integer but they change corresponding to what options you have checked in the database options tab. ...

The whole crosstab thing comes up so often that when I get time I go back and look at taking the cursor out of the procedure.  I really want to...

I looked at the procedure when the thread first posted.  I even tried to combine mine and yours together because I need something more dynamic.  I'm still working on taking...

I agree with Jeff.  Forum posters benefit the forum by providing help and are benefitted by the forum by recieving help.  Advertisers benefit the forum by paying for the upkeep...

JLKs method works if you have a known set of data that you want to crosstab.  If it will vary this procedure works pretty well although it uses a cursor. ...

use the extended procedure xp_sendmail. Check BOL for the syntax.

if package logging is turned on for the package you can right click on the package and click package logs.  To see if it is turned on design package, righ...