Either append the character to the end, like the string parser does, or include something in your Where clause about "and charindex(...) > 0".

Multiply the counts inside the sub-queries by 1.0.

Was there an increase in the amount of data it's handling?

Do you mean like this:

select (SELECT Count(CallLog.ClosedBy) AS Tracker From CallLog WHERE ClosedDate Between '2009-09-01' and '2009-10-30'and Tracker = 'Troy'(

/

(Select Count(CallLog.RecvdBy) AS Tracker From CallLog WHERE RecvdDate Between '2009-09-01' and...

I don't understand what you're trying to resolve with this. I ran it, and got output, but I don't understand what the problem is, so don't know where to...

Before I could even begin to tune this, I would need the create scripts for all the source tables, insert statements for some sample data for each, and the expected...

Hate to say it, but when I had to remove a copy of SQL Express that had been messed up from a workstation, I ended up wiping the machine and...

There are dozens of uses.

Search this site for Tally table or Numbers table, you'll find a number of articles and dozens of threads where they come up.

http://www.simple-talk.com has a workshop...

Which article are you asking about?

Will DateDiff(Week) from the start date of the year give you the week?

If an index is below a certain size, reorganizing it won't get rid of fragmentation, because the fragmentation really doesn't matter. Is that what you're running into?

Since I don't have a copy of your table, and don't know how it's built, I had to build a table of my own to build the query off of...

Try making it "sum(a*1.0)" in the numerator. See what that gives you.

Try this:

create table #T (

ID int identity primary key,

AddressFull varchar(1000));

insert into #T (AddressFull)

select 'Mid-Penn CDC

21 South 12th Street

Philadelphia, PA 19108' union all

select 'Line1

Line2

Line3 12345';

declare @Delimiter char(1);

select @Delimiter = '

';

;with

Numbers...

People trying to justify their own illegal/unethical/immoral activities can get very annoying. Usually starts with "it's none of your business".