Recent content by GRHE

Sorry going bonkers, I asked this in 2005 -- please ignore me :)

Hi Any pointers where to find help on saving out to a file, using t-sql, some xml that is stored in a ntext?? Cheers GRHE

Hi Has anyone using SQL converted a string into Base64 and inserted into a column? Many Thanks

Sorry this is all I found and works like a dream for me -- :)

http://www.databasejournal.com/features/mssql/article.php/1443521 Easy Peasy !!!

Hi I have been given a database which has a PDF file stored in an IMAGE column. How do you extract this into a usable .PDF file using SELECT ???????? Cheers PS> I have searched through previous threads, but can't find one with the answer...

Andrew, Any chance of forwarding your example to me John.Grindle@dorset.pnn.police.uk Cheers John (alias grhe)

Steve Thanks for your quick reply. I guess the VB solution is our only way round, or we print all the reports and post them to the users!!! I also thought you were local to me "West Bay" but you are a few more miles away http://www.bridportandwestbay.co.uk/ Cheers GRHE

Hi We have just taken our 1st steps into Business Objects and created a suite of reports as PDF files. These reports we now want to run overnight and publish the results as PDF files onto our intranet. We understand that Broadcast Agent is the way to go - but is it worth the licence fee -...

Thanks Nimmy, that's exactly what we did and it's working well. ie. create a new database on the SQL, just populated with views, pointing to the other database tables... Cheers

Hi We are using business objects 6.1 accessing our Microsoft SQL 2000 Server. We have come across a major problem where we can't access tables from different databases, but still on the same server! Yes, it does allow us to drag and drop them into the universe creator. But it does give us...

Cheers Sis That's what I thought, but best to check before I went too far ....

Hi All can you create a foreign key to an existing table that works the same way has having 'Left Outer Join' in a Select statement. So that all rows in table 1 are displayed, even if they don't have a valid key to table2?????????????? TABLE1 TAB1KEY int TAB2KEY int CONTENT char TABLE2...

Cheers I can go to the pub now :)

I have a group of four selects all union'd. Is there a way of getting the top 1000 of "all of the results". I have tried top 1000 in each of the selects but that returns 4,000?? It's Friday and I want to go hom :)