Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to add two parameters into VIEW
I created tmp_table whre I am writng parameters... anyway thnax for help -
Need to add two parameters into VIEW
Is there any way to send two parameters: PARAMETER_dateFrom PARAMETER_dateTo into my view (see below) called from outside? I expect query like this: select * from v_customFieldString where bug.id = XXXX and send in some way PARAMETER_dateFrom, PARAMETER_dateTo create or replace view... -
how to join two select?
I need to create view from two select statements, need to join them. 1. select A.id,A.projectId,A.lastUpdated,A.oldValue from ( select bug.id as id ,bug.project_id as projectId ,bug.last_updated as lastUpdated ,his.old_value as oldValue from table1 bug left join history his on bug.id =... -
-
How to get number of months between two dates
you sure that MILLSECS_PER_Month is constant? -
How to get number of months between two dates
need months difference, f.e. Dec 2006 - Feb 2007 = 3 months -
How to get number of months between two dates
How can I get number of months between two dates crossing the year? -
getMondayDate from weekOfYear
how can I get date of Monday accroding given weekOfYear public Date getMonday(int weekOfYear){ ... } -
group_concat change separator
had bad syntax in my code. this works: group_concat(column separator ';') -
group_concat change separator
Hi all, how can I change separator in result of my group_concat? thanx -
Subselect problem
Hi all, need help with sql cript. let's have these rows: Col1 Col2 ... Coln 1. Project1 Notes1 ... 2. Project1 Notes2 ... ...... 10. Project1 Notes2 ... and I need to get this result in one row : Col1 Col2 1. Project1 Notes1,Notes2,Notes3....Notesn how...
