Database

SELECT CAST(RAND() * 1000 AS VARCHAR) AS [Random_Number]

Try to use Unicode instead of a special Windows code page. 2) Indian fonts are not very common, I wouldn't expect to find any Indian fonts except perhaps Devanagari on a "normal" computer. You have to install the fonts. In Ubuntu (I guess you mean Ubuntu when you say Ubantu), some South Indian localizations are available for the system, I don't know for Kannada. Just install some of these localizations, and the respective fonts will also be installed. Then test with Firefox and a web page in that language. Oh, let's try: ಕರ್ನಾಟಕ

Do you mean Indexing? Google it! ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

djj55 wrote: You would need to calculate the maximum average in this query. how i could do this?

Timothy CIAN wrote: how does the performance compare, generally speaking? In my experience that all depends on the DBA, some DBAs are good and can make anything sing, others not so much. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

You have already posted this message in this forum. Repeating it will only annoy the people who might otherwise give you a solution. Software rusts. Simon Stephenson, ca 1994.

Here you go You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or a later version[^] Reporting Services - Troubleshooting[^](search section 5.4 “The request failed with HTTP status 401: Unauthorized”) For you information How to implement impersonation in an ASP.NET application[^] thatraja **My Tip/Tricks My Dad had a Heart Attack on this day so don't... **

Sorry for the rant, but even WinXP has a 'search' function in it's Explorer, so you should easily able to locate the file - if it exists ... {Addition] www.giyf.com the 4th result (from ora-00603) leads to a response like: ???\oracle\admin\aso\udump\aso_ora_1360.trc HTH modified on Wednesday, April 13, 2011 6:10 PM

I have run into this a couple of times, look for a {file name}.rdl.data file and delete it it. That contains a cached set of data for the report. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

Answerred the later post. The need to optimize rises from a bad design.My articles[^]

RESTORE DATABASE AdventureWorks2008R2 FROM DISK = 'd:\SQLServerBackups\sampleDB.bak' WITH FILE=1, NORECOVERY;

just the following,- order by LruName, ChName, Type DESC

SELECT current_date FROM dual; or SELECT SYSDATE FROM dual;

Although the data type is char, but the data in the column is numeric then you can convert the field and then compare. select * from table_name where cast(field_name as int) = 100; Om Prakash Pant

Turns out the network folks were backing up the entire database every 60 seconds. Without telling us. Performance is fine now that we turned that off. About 25% greater than local file. Thx for the pointers. Mark Jackson

You have already posted this in the Q&A section. Try avoiding cross-posts. The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

If you are just moving the database do backup/restore or detach/attach. These create the tables for you.

You're welcome :) The need to optimize rises from a bad design.My articles[^]

Yes, I understand. Just for the future use, if the code is the key to the city, you should have a lookup table for cities and fetch the name using a join. For example if the city name changes you'll now have to update part of the string field to correct the situation on every row. At some point when you have time, have a look at W3Schools web site. There's lots of basic theory in clearly explained format. Even though it's mainly MySql, the theory is much the same. For example this could be interesting: http://w3schools.in/php-mysql.php?tutorial=Database-Normalization[^] Good luck to the project :) The need to optimize rises from a bad design.My articles[^]