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 … |
0 Reputation Points
0 Endorsements
Ranked #5K
~2K People Reached
Favorite Forums
Favorite Tags