Viewing 15 posts - 241 through 255 (of 1,183 total)
Because you're dividing two integers and not two decimals.
30/100 = 0
30/100. = .3
SELECT 30/100, 30/100.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2011 at 9:06 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2011 at 8:43 am
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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 2, 2011 at 8:14 am
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?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 23, 2011 at 8:23 pm
Stuart Davies (9/15/2011)
bitbucket-25253 (9/15/2011)
Stuart Davies (9/15/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 15, 2011 at 9:56 am
as with everyone else. 2nd select returns 1 not 2.
Thanks for the credit Steve 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 15, 2011 at 8:53 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 19, 2011 at 8:06 am
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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 11, 2011 at 8:15 am
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,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 4, 2011 at 8:26 am
Study up on Windowed Functions, they can be very beneficial. 🙂
Using your sample data ...
SELECT DISTINCT
DenialCode
,CAST(
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 2, 2011 at 7:01 pm
^-- I added in the REVERSE function to help with the possibility of not have four sections.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 10:45 am
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
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 10:43 am
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'
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 8:57 am
bopeavy (7/27/2011)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 7:47 am
*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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2011 at 7:22 am
Viewing 15 posts - 241 through 255 (of 1,183 total)