Search results for query: *

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 :)

Hi Why did we design a system, maintain it for nn years and only now decide we need a Managment System, maybe it should have been the 1st thing we did!! Ho Hum So, what Configuration Management tool do you use and is it any good?? Cheers

Work it out for my self... Feeling a lot more refreshed today and decided to get to the bottom of it. The way round this is to create a text file, but call it a .xls and when it is emailed to the user they just open it using excel.. it works .....

Feeling fragile, I had a bad night last night -- too much ale! So please help me, I need to export data into an excel file. I have tried and there are two things that I can't seem to resolve - 1. the file must already exist for it to work - is this the case??? 2. Because the file already...

Ok dont panic I have just found isnumeric(

Hi Long time and no stupid questions from me! But in a procedure how would you detect a numeric value in a char(10) ie. declare @sp char(10) set @sp ='4' -- its numeric set @sp = 'hello' -- it aint numeric Many Thanks