How to decode CAL_INFO from MSP_CALENDARS table?

J

jpa

Hi all,
(using MSP2007, SP1, PIU)
Using Project Pro we are able to enter team members absence (date + name).
I'd like to decode this information within a report (using Reporting
Services).
My understanding is that those data are stored within CAL_INFO field of
MSP_CALENDARS table in the PUBLISHED database.
CAL INFO data type is (image, null). "image "data type means
"Variable-length binary data with a maximum length of 2^30–1 (1,073,741,823)
bytes".

Can someone help me about how to decode such CAL_INFO field?
(either SQL command or db procedure or VB script)
Thanks in advance
jpa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to decode CAL_INFO field from MSP_CALENDARS table (PUBLISHED d 0
how to decode CAL_INFO field (MSP_CALENDARS table, PUBLISHED db)? 1
Reporting Services: how to know when people are absent? 0
Add new dimensions to (timesheet) OLAP cube? 1
How to get Project global Schedule status from Tasks Schedule Stat 3
I need to compare a value from one table and return a result from another ie Decode 0
Help needed passing data from the form to a table. 0
One table or two? 11

Top