Search results for query: *

Getting only one record back from OpenXML... Why???? When I run Select XMLString From CAPSProgram I get my expected results.. Expecting to get 250 below is the code from QA: EXEC sp_xml_concat @hdl OUT,'(Select XMLString From CAPSProgram)a','XMLString' SELECT x.* FROM OPENXML (@hdl...

I glaced at it and it look like something I had already tried. It did the trick, thanks very much. Will keep testing to see if it works all variations of the data.

Do I need a subquery for this cause I need to interigate two fields on the same record? What is the general rule with two fields (or more) detemine if the record belongs in in the result set.

Not sure how this is going to come over but here is the data I'm working with. As you can see there is a Yr and period field. I want all records except year Not 2006 and Not > Period 4. Everything except the first record. The user will have the ability to choose which peiod and year they...

All, Have an account balance table with fiscal year and period. Need to create a trail balance file from this table. All I have to do is add all debits then all credits for the account from the beginning of time to the specified month, there is the problem. Cause the there is a (fiscal...

These are rlease notes. What I'm trying to find out is how to use a product called eProtfolio. Where from what I saw from a demo is where your reports are kept and drive. It was a web page will all your reports listed so the user can click on the report he wants to run.

All, Have several 8.5 reports that are driven from a VB 6 app and shown through the cr viewer control. I need to webify the reports so we can see them over our intranet. Just installed crystal 10 and Enterprise embedded. My question what do I do now? Do I create a web page and use the viewer...

I have a screen which saves the content of the screen to a table. I would like to put in some functionality before the record is appended to see if it already exists. Any ideas?