Because you're dividing two integers and not two decimals.

30/100 = 0

30/100. = .3

SELECT 30/100, 30/100.

Amy,

In my humble opinion this is almost the hardest thing to tackle. At least in the environment you've described. If there is no one to smoke test your approach or...

Change the font of the cell/textbox to WingDings. Use the character map under (Accessories > System Tools) to find the graphic you want and place that in a =IIF statement.

This may sound silly, but do the page sizes match with report properties and page properties and subsequently the printer properties that you're using?

Stuart Davies (9/15/2011)

---

bitbucket-25253 (9/15/2011)

---

Following quote, high lighting added by this poster

Stuart Davies (9/15/2011)

---

Thanks for the question. I've only submitted a couple over the years and know how quick others are...

as with everyone else. 2nd select returns 1 not 2.

Thanks for the credit Steve 🙂

You must also group by the case statement.

select count (*) as 'Total', problemcode, category = CASE problemcode

WHEN 'WEB0-SU01' THEN 'Candidate Site Issues'

WHEN 'WEB0-SU02' THEN 'Recruiter Site Issues'

WHEN 'WEB0-CNDD-PPLF-MNDN' THEN...

Yes, you can install them on the same machine. I do not believe there are any special actions during install other than making it a seperate instance.

This code is simplified, not so sure about a performance gain though. You might find more gain from looking into the vw_EmployeeInfo view.

SELECT

s.Mth,

...

Study up on Windowed Functions, they can be very beneficial. 🙂

Using your sample data ...

SELECT DISTINCT

DenialCode

,CAST(

...

^-- I added in the REVERSE function to help with the possibility of not have four sections.

No While Loops, No functions, No tally tables ... 😀

Works with any number of version "dots" up to 4

;WITH sampleData (appID, appVersion)

AS (SELECT 1, '10.1.55.3366'

UNION

...

How about ....

;WITH sampleData (appID, appVersion)

AS (SELECT 1, '10.1.55.3366'

UNION

SELECT 1, '10.1.99.64'

UNION

SELECT 1, '10.1.1.1'

...

bopeavy (7/27/2011)

---

I have a table like this one:

CREATE TABLE [dbo].[CH](

[exid1] [int] NULL,

[exid2] [int] NULL,

[exid3] [int] NULL

) ON [PRIMARY]

-----------------------

INSERT INTO [Test].[dbo].[CH] ([exid1],[exid2],[exid3]) VALUES('0','0','3')

INSERT INTO [Test].[dbo].[CH] ([exid1],[exid2],[exid3]) VALUES('0','1','2')

The columns have numbers 0...

*Don't kick yourself too hard, but the answer is simple if you step back and take another look at it.

Use PIVOT and do a MAX on the ClassDtls column. This...