Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for your recommendations
Actually main point for me is "how to normalise the table structure" because I cannot decide anything about new columns creation: it is done thru an application...
December 23, 2009 at 2:31 am
Thanks,
Finally I used following solution
If @Param_Year = '2009'
SELECT col_2009_name1 AS name1, col_2009_name2 AS name2
FROM my_table"
else
SELECT col_2010_name1 AS name1, col_2010_name2 AS name2
FROM...
December 22, 2009 at 8:04 am
Just to inform that I finally solve my issue using temporary table (keeping CURSOR and WHILE loop mechanism):
actually I am using "variable table" type of temporary table , steps are
1)...
September 29, 2009 at 10:22 am
I had a look on CTE but unfortunately I don't think this is adapted because the data processing I do are more sequential than recursive.
In the meantime I also tested...
September 29, 2009 at 8:28 am
I did many tries without any succes:
- the "select * from (my queries) as T" still generate different result sets
- If I try to put "select * from" at the...
September 29, 2009 at 6:10 am
To answer your question, Name will never be empty: in addition in my "complex" query I do specific things like ResourceName = ISNULL(table1.ResourceName, t .ResourceName) which can only be done...
September 29, 2009 at 5:35 am
Hi bendy-983487
Thanks for your reply
I fully understand your 2 proposals (which I actually use within other reports).
The point is that the "complex" query is very specific to a user (with...
September 29, 2009 at 5:10 am
Viewing 7 posts - 1 through 7 (of 7 total)