Viewing 15 posts - 136 through 150 (of 284 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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2015 at 3:35 pm
Nevermind
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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:]
...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 13, 2015 at 9:49 pm
derickloo (4/8/2015)
Thanks LinksUp. It's work.
Glad it worked for you. 🙂
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 10, 2015 at 10:03 pm
derickloo (4/7/2015)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 ...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 @b-2 table
(
...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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,
...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 4, 2015 at 4:50 pm
maruthipuligandla (2/24/2015)
ResumeSkill Skill
Id ...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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.:-)
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 23, 2015 at 9:45 pm
Viewing 15 posts - 136 through 150 (of 284 total)