I'm having the same problem.  The PDF comes through as nothing.

is there no easy way to simply do something like create a pass-through query and have something along the following:

exec testquery Forms!Test!Start,Forms!Test!End

I thought for sure I'd seen such a beast...

With some modifications to my other structures, yes it worked. 

Thanks much everyone!

set @y=(select charindex('_',childcamp) from [stats-2] where counter=@t)

I'm using the charindex, but what's happening is that it seems to be basically ignoring my where clause and not giving me the...

Well, I'm looking at the union aspect of things and really not liking it, but I'll give it a shot for my application.

And the reason I'm not wanting to do...

The national DNC registry does work, but unfortunately the people who are some of the largest abusers (Politicians / Poll Takers / Newspapers / Charities) are not subject to the...

It's not that I keep things in different tables, I guess I'm not conveying the flow.

What happens is that these tables that are created are exported out of SQL and...

Another question along this same issue.

I'm trying to create the insert statement and am running into problems because I use the - as part of my @FileName variable.  Anyone know...

NM, I figured it out with AJ's answer.

Thanks much.

Can you elaborate on this, I'm sorry but I don't understand I guess.

I'm wanting to send the proc the following:

exec processcold 'ABCD','2,'TX'

I'm wanting the proc to create a table named:

ABTX6-30-2

With...

Govin,

I'm building the name of the file in the proc, therefor when I try the declare method you posted, I'm receving an error about a duplicated declaration.

Sushila wins the whole she-bang.

I kept thinking that I wanted to use default under the EM instead of formula.  As soon as I typed what I wanted under formula I...

I'm a he btw.

As for why I don't use top 25 percent,etc it's because we create "dialing files" of anywhere from 25k to 250k depending on various factors.  Therefore my...

Remi,

I think it's getting way off topic for what I need.  I can sort and get the leads and such I'm needing fairly easily without creating a "long" SQL statement...

Phone is varchar(10) and Sort is an int value.  (9015551212 would be a sample) with Sort being 12.

I'm talking doing it in Enterprise manager although I can always create the...