0 - 5 of 5 tags for undefined

All,
 
I'm trying to filter the DBQL and noticed that timestamp does not support a format WITHOUT seconds (ie:  'MM/DD/YYYY HH:MI).  Therefore, I found a workaround appending :00 as a constant for the second:
 

I have below procuedure but it has some performance issue. I'm trying to convert it to set logic, but not sure how to.
Can you please help?
The current procedure is like this:

Hi,
I have a date column upon casting it shows the result in differnt format in differnt environment.
here is my query.
 
SELECT DT_END_RANGE AS A ,CAST(DT_END_RANGE AS CHAR(10)) AS B , CAST(CAST(DT_END_RANGE AS CHAR(10)) AS DATE) AS C FROM TAB1 WHERE YR=2014
output in 1 environment:
A    B   C

Input table should hown be converted into output as shown below.

Country          State

India               Ka

India               Kr

India               Dl

India               Hk

 

output should be

___________

Country          State

India               Ka,Kr,Dl,Hk

Hi!

I am not allowed to create a procedure. But I think I'll have to implement a loop within a macro for the following scenario. Suggestions other than loop are welcome too.
This is my lookup table.
Team Hierarchy Count SEQ_NUM
Team-B 1 22774 1
Team-J 5 7114 2
Team-O 3 59071 3
Team-R 1 11387 4
Team-R 2 1637 5
Team-Y 2 4092 6