Recent content by killerkoolkris

Hi antzzz, Nikhil here is right. U can generate insert statements using DBArtisan. We can do that by choosing the DBArtisan -> Schema Extraction option. It has got a very easy wizard interface which can be used for generating the insert statements for any table. cheers, KK

Hi All, Think i might be a bit late for posting a reply .. But i have tried this one and its real kewl .... Maybe it might be worth a look ... (for some future use maybe ..) http://www.zlib.net/ cheers !!! ;-) Killerkoolkris

Hi sparked, Your problem is very interesting. I think you will have to use a combination of union and temp tables. Here's what you can try. 1) first get all the non duplicate records using a group by key, count(*) having count(*) = 1 into a temp table. 2) get all the duplicate records into...

Hi JohnVai, I think this will be of help for you. If you only want to show the first 50 rows then try set rowcount <<50>> select * from <<TABLEA>> order by <<column1 desc>> set rowcount <<0>> The set rowcount will assure that only the number of rows mentioned in the statement will be returned...

Hi, I want to perform a mathematical function for calculating the median for the values in a particular column containing numeric values. Is there any inbuilt function which can be used directly to perform this function ? If not what can be the alternative solution ?? Thanks in Advance...

Hi, I am currently having a set of 20 items which i am showing in a dropdown list. Some of these items are more than 255 characters in length. I am facing 2 problems - 1) if i show the list using a single column then the items having more than 255 characters appear as '######' and one can view...

Hi, I am a newbie to XML / XSLT. I am currently facing a problem. Below is the prototype of a XML i am using. <xml> <row> <field1>1</field1> <field2>1</field2> <field3>1</field3> <field4></field4> </row> <row> <field1>1</field1> <field2>1</field2> <field3>2</field3>...