Anyone can help me?

Another question...

How do I change the row data into column? Refer below:

Expected results (By Rows)

---------------------------------

UserID param_value EnterDtm

1001 182 2008-02-28

1002 152 2008-03-02

1003 114 ...

Thanks a lot!

I get the needed records! :-D:-D:-D

the report is working as following.

1. User enters a large number of ocmi.name values in a form. It is about 300 ocmi.name is used to build the form.

2. These are...

Thanks for your answer. Pls find my comments

For Q1:

Param_Value =

case when ocmi.name = 'SHS_CDM_OI_PatHx2' then isnull(valuetext,value)

else 'NA'...

Thanks... I get the access to create and drop my own table.

But appreciate if you can answer below question,

** I still have no right to create stored procedure!

my...

Thanks..

my problem is I am have no the CREATE right to the db.