Search results for query: *

Try using || instead of + something like this: SET RTime = RDate || ' ' || RTime

Nikol, Your query (or the o/p shown) is not very clear to me. I understand ur 'household' table (ID,hold_id,& relationship columns). Can you give a sample of ur other table which contains age?

Try this: UPDATE customer C SET code = (SELECT code FROM updates U WHERE U.code = C.code) WHERE EXISTS (SELECT * FROM UPDATES U WHERE code = C.code);

Not sure if this would work, but try using TOP (not sure of TOP syntax below) to get the top 4 rows of your result, after doing a group by year, Quarter desc (assuming you have Year and Quarter fields in your table as shown in sample data above).. Try something like this: select * from...

Jake1, If you can be more clear on what exactly is not working...it would be easy to help. Anyways, since you said u created a hotfile to get the description of the code, i am assuming 'description' is in a different database. If code and description are in the same database, then you could...

Hi, We added couple of more dimensions to a cube and the drill thru stopped working. It gives error in page. The reason being the URL length exceeds the maximum limit of Internet Explorer (2083 characters). The drill thru's in default view of the cube work fine.But since we create a view...