I rarely get the luxury of "calling the ball" on what kinds of data I get, but given the choice - I would definitely also steer towards three separate files....

You might care to consider not always putting the leading % in there if you don't absolutely have to. This forces a scan of whatever is returned by the...

hehe - it would actually be funny if it didn't happen that way so very often....

Glad I could help though!

scroll down - under the post options is a little bar called "last 10 posts in descending order". Hit the + in there, and voila....

Jeff Moden (2/22/2008)

---

Understood... but this doesn't even have anything to do with indexing... changing a constant to a variable causes a massively detrimental change in the execution plan. This...

Which column is NULL?

If a country code is mentioned once in any row - it should show in the column list, and put NULL next to the ones...

Hard to be helpful. Not much to go on...

Are we using shell or xp_cmdshell?

What DOS-based command is being used to "convert" this PRN file?

What is the character that gets...

You need...

I'm not sure I'm catching all of the details, but it doesn't sound like you need a cursor at all.

Assuming your temp table was the source and you wanted to...

The only issue with putting the sending an e-mail through a trigger is that any failure during the trigger execution will make the trigger AND the action roll back. ...

The one thing you might ask them is if they can prevent access to SQL from anything other than that box (that's a firewall setting). Meaning - the only...

For what it's worth - I've found that it's often necessary to blow away your indexing assumptions, and try others. Meaning - it seems that 2005 might prefer an...

Mike -

If you happen to set ANSI_NULLS, then it CAN be true....

Try this:

set ANSI_NULLS OFF

go

select case when NULL=NULL then 0 else 1 end

go

set ANSI_NULLS ON

go

select case when NULL=NULL then...

I didn't answer that very well. Let me rephrase.

Your initial question is whether you can PIVOT without aggregation. The answer is no: PIVOT requires aggregation....

Agree with John - with a few syntax corrections....

drop table MyNewTable

SELECT top (10) IDENTITY(int,1,1) as RowID, * --top 10 need to be in the SElect, not the from

INTO MyNewTable...