Viewing 15 posts - 4,201 through 4,215 (of 5,109 total)
Maybe..?WITH RN AS (
SELECT t.[STATUS],
t.RequiredByDate,
t.WorkOrder,
DENSE_RANK() OVER (ORDER BY t.RequiredByDate DESC)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2017 at 7:16 am
MSDN gives pretty good detail and examples on how to use these functions:
LEAD (Transact-SQL)
LAG (Transact-SQL)
They effectively work in the same way,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2017 at 5:57 am
I have a matrix report and the query used on the report
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2017 at 5:04 am
What was your actual aim here, was it for grouping, display purposes? Changing the data type of a field (in this case DATE to STRING) isn't always the best idea....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 23, 2017 at 5:32 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2017 at 7:44 am
Insert a List object into your report, and set it to use the required dataset in its Tablix Properties. Then create a grouping on that list for your Country field...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2017 at 4:28 am
It's a definite shame for the newer users, who clearly have tried their best, but don't quite understand some of the principles. The ones that maybe do post a screenshot...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2017 at 2:11 am
Whydid you use the old Sybase syntax for your insertion statement? Itwas replaced...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2017 at 2:05 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2017 at 1:51 am
Please supply DDL and sample data in a digestible format for T-SQL. You'll get a much quicker answer.
One solution, using PIVOT:CREATE TABLE #Sample (ID VARCHAR(10),
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2017 at 5:31 pm
Can you supply some DDL and sample data? We can't access your data, so we need something to work with.
Thanks.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2017 at 7:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2017 at 7:34 am
As the others have said, this is presentation layer. If you were to reduce the accuracy of a column that contained 0's, you would have to apply that logic to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2017 at 7:31 am
0.00 does equal 0, rounding it is still going to give you the same result (0.00). What is it you are after here exactly, only the Integer part of the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2017 at 7:13 am
Those specific examples you gave will work fine for that query, however, the problem is that somewhere in your data, you have something that doesn't work.
You could filter...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 20, 2017 at 1:24 pm
Viewing 15 posts - 4,201 through 4,215 (of 5,109 total)