Viewing 15 posts - 136 through 150 (of 283 total)
DonFord81 (5/22/2015)
How do I write an expression in the report that will, in the above example, give me the value 175 (i.e., the average of 200 & 150 for the...
May 22, 2015 at 3:35 pm
Nevermind
April 24, 2015 at 9:42 pm
L30 (4/19/2015)
I will have to study your solution a bit, I don't understand the syntax as yet. :w00t:
The key is the Row_Number function. Row_Number does just that. It numbers the...
April 20, 2015 at 8:27 am
This is a guess at the output you are looking for:
declare @file_num varchar(20)
set @file_num = '001/100/011/00002'
SELECT
CAST(cntfl.file_no AS VARCHAR) [File No:]
,CAST(cntfl.file_part_no AS VARCHAR) [Part No:]
...
April 16, 2015 at 12:17 pm
This looks like homework.
You should read the link in my signature line to lean what to post and include what you have done so far.
Mapping what you did...
April 14, 2015 at 9:52 am
L30 (4/13/2015)
I can successfully use this query to get some of the data.
.
.
.
INNER JOIN std_bxct as stdbxct on stdbxct.bxct_file_no = cntfl.file_no
INNER JOIN std_aud as stdaud on stdbxct.bxct_box_no = stdaud.aud_file_no
where file_no...
April 13, 2015 at 9:49 pm
derickloo (4/8/2015)
Thanks LinksUp. It's work.
Glad it worked for you. 🙂
April 10, 2015 at 10:03 pm
derickloo (4/7/2015)
April 7, 2015 at 8:06 pm
v-swgar (4/6/2015)
UID PreviousDueDate CurrentDueDate
----------------------------------------
PT-01 2015-04-20 2015-06-30
PT-02 2015-04-22 ...
April 7, 2015 at 12:25 am
The posting of the dll and data was very helpful!!
I was able to modify my earlier post to get what I think is what you are after.
declare @start_date datetime...
April 6, 2015 at 10:41 pm
These queries give what I think is your required output"
Table and data setup
declare @a table
(
Name char(10)
,StartDate datetime
,EndDate datetime
)
declare
April 6, 2015 at 10:36 am
vipin_jha123 (3/12/2015)
Msg 8672, Level 16, State 1, Line 6
The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches...
March 12, 2015 at 12:29 am
There are a ton of date routines to do all sorts of things.
Here is a very simplistic example:
select Month(dateadd(mm, -1, '2016-01-15')) Mon,
...
March 4, 2015 at 4:50 pm
maruthipuligandla (2/24/2015)
ResumeSkill Skill
Id ...
February 24, 2015 at 11:40 pm
mister.magoo (2/23/2015)
Isn't that just a mighty complicated way of saying:
select min(fromdate) as fromdate, max(todate) as todate, Customer_Number, Contract_Number
from @t
group by Customer_Number, Contract_Number
order by Customer_Number, Contract_Number;
Well, there is that.:-)
February 23, 2015 at 9:45 pm
Viewing 15 posts - 136 through 150 (of 283 total)