tatarao25

Hi, please give me any idea to open pivot excel file in web broser insted of saving dilogbox

Hi Everyone, I am facing the following problem: My connection to SQL Server 2000 (Enterprise Edition with sp4) is fluctuating a lot. It gets disconnected after one or two hours and remained so for 2 - 3 minutes and again re-establish or sometimes I need to restart the SQL Server …

hi all, i have written store procedure which is working fine in MySQL browser the problem i am facing is when i call store procedure through c# usng nhibernate it is throwing exception MySQL.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is …

hi every one, equivalent ExtractValue() function to read xml content stored in table in mysql 5.0 version

SELECT ExtractValue(bulk_custom_field_string,"//CustomFieldValue")as CatalogValues FROM candidate_work_profiles i am getting output as 'false No 36 January 2007 January 2010' i want output as Separate Column false|No|36|January 2007|January 2010 please help me

hi every one, i am trying to store store procedure result into temporary table tried using DELIMITER $$ DROP procedure IF EXISTS `Merge` $$ CREATE procedure `Merge`() begin create temporary table table1 call sp1(); create temporary table table2 call sp2(); End $$ DELIMITER ; error :: Script line: 3 You …

hi every one, how to return table using functions i tried DELIMITER $$ DROP function IF EXISTS `test` $$ CREATE function `test`() returns table begin return (select * from users); End $$ DELIMITER ; error: Script line: 3 You have an error in your SQL syntax; check the manual that …

hi evry one, my problem statement is i have table as follows [CODE=text]jobId | stagename | Count 623 Technical Screening 5 623 Technical InterView 3 623 Second Interview 6 623 Final Interview 7 623 Hr Interview 1[/CODE] i want Query To Display result as given below [CODE=text]jobId |Technical Screening | …

hi all, I hosted my website in iis6 in windows server 2003 having one application pool running 2 w3wp.exe process. problem i am facing, when one process exceeds is size Limit it is transferring to 2nd process while transforming it is taking long time and it is showing Time out …

Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 …

hi all, i am writing store procedure so please send me steps to follow that increase the performance

hi all, i am using temporary table to store ids,from this i am calculating the records count,it is working fine and i am getting the result.The problem is i am getting warning that temporary table does not exists

if @fromDate = Datetime.MinValue BEGIN set @fromDate = (select MIN(applicant_statuss.created_on) from applicant_statuss) end if @toDate = Datetime.MinValue BEGIN set @toDate =GETDATE(); end the following error is Comeing : Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 21 The column prefix 'Datetime' does not match with a table name or …

hi every one my problem is is to convert id column values as comma separated ex: id 1 2 3 4 5 6 i want result set as string "1,2,3,4,5,6,7....."

I am using Mysql Database with C#. problem is i am using datediff() function returns int that value is stored in C# property int variable while assign giving error as cannot covert system.Int64 to System.Int32. please provide me some idea abut this error.

hi every one,i developed windows application and installed on laptop having 1900 higher resolution, the button, labels, text box controls are overlapped but i is working fine in low resolution laptop

hi evey one, i want mac address in windows 7 code i written to getmac address: [code=C#] String NicCardAddress = null; foreach (NetworkInterface nic in NetworkInterface.GetAllNetworkInterfaces()) { if (nic.OperationalStatus == OperationalStatus.Up) { NicCardAddress = nic.GetPhysicalAddress().ToString(); break; } } [/code] i am getting two addrress one for lan and another for …

hi every one,i have one problem with DateTimePicker, i am displaying only years in dtp by setting custom Format property to yyyy and dtp format to custom and showupdown property to true. the problem is when i click once down arrow or up arrow the years in dtp continuously changing …

hi evey one ,i written code in c# language to take sql server 2008 backup using Sumo objects i am getting the error saying backup failed to [servername],the code is writen as following [code] try { sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); sqlServer = new Server(new ServerConnection(sqlConn)); dbList = new List<Database>(); foreach …