Tess James

When data volume is huge on a page, application is really slow in IE 11 compared to IE 8. For e.g. There is this page where a drop down list is bound with 23 K items (This is taking things a bit too far in terms of design, I know!). …

I need to copy only some selected rows from a table and insert these rows into another table (having the same structure) in another database. Is it possible?

Recursive CTEs can be used.

> - Currently, when the program asks the user to input a column, it will accept any number and continue when there are only 3 columns. Put a validation after taking the user input. If the validation fails,ask the user to enter again. > - Also when "Round: 1" is …

Make use of the string functions SUBSTRING() and CHARINDEX().

[CODE] <div id="divTxtbox" runat="server"></div> [/CODE] [CODE] protected void Button1_Click(object sender, EventArgs e) { int a = 3; for (int j = 0; j < a; j++) { TextBox textbox = new TextBox(); divTxtbox.Controls.Add(textbox); } } [/CODE]

Get the output of query (a) to a temp table with an identity column as RowID [CODE]declare @EmpIds table ( RowID identity(1,1) int, empid varchar(20) ) declare @count int select @count = max(RowID) from @EmpIds while (@count > 0) begin select @empid = empid from @EmpIds where RowID = @count …

Try this query. [CODE]Select Itemid, Datephysical, isnull(max(Case when Statusissue = 1 then Qty else null end),0) as ReceivedQty, isnull(max(Case When Statusissue = 0 then Qty else null end),0) as TransferQty From #Table1 Where datephysical >='2012-02-14' and datephysical < '2012-02-15' group by Itemid,Datephysical[/CODE]

[CODE]select ((select count(1) from TableA where Condition1 ) / (select count(1) from TableA where Condition2 )) as ratio[/CODE]

* There should be a space between the keyword case and the value [CODE]case 1[/CODE] * Break statement should be there in each case block

All syntax errors.

(length of string1 without spaces - similar count of string1 ) + (length of string2 without spaces - similar count of string2)

Gender == CHAR(1) --- Either 'F' or 'M'

Add a GO statement after DROP statement. But why do u want to have the same table declared twice?:?: I don't see any schema changes in the second declaration.:confused:

Try something like this. [CODE]System.IO.Directory.CreateDirectory("SomePath\NewFolder");[/CODE]

Am gettin an error msg like this--> The image “[url]http://localhost/linegrph.php”[/url] cannot be displayed, because it contains errors. while tryin 2 run my code on localhost.. Wen I comment d statemnt, $graph->Stroke(), nthng at all displys.. Plseeee do tell me a solution.. Thnks in advance :)

[CODE]create table #table ( id varchar(10) ) select * from #table declare @max varchar(10) declare @default varchar(10) declare @newid varchar(10) declare @alphabet char(1) declare @number char(2) select @default = 'AA00' if(exists (select 1 from #table)) begin select @max = max(id) from #table select @newid = 'A' if( right(@max,2) <> '40') …

r u saying the below kind of query is not working?? update t1 set t1.Quantity = t1.Quantity + t2.Quantity from table1 t1 inner join table2 t2 on t1.Item_id = t2.Item_id

Try something like this in the where clause.. i assume that u store month id in your table. where ( (monthid in (1,2,3) and month(getdate()) in (1,2,3)) or (monthid in (4,5,6) and month(getdate()) in (4,5,6)) or (monthid in (7,8,9) and month(getdate()) in (7,8,9)) or (monthid in (10,11,12) and month(getdate()) in …

Try inner join.. SELECT t2.LetterType FROM table1 t1 inner join table2 t2 on t1.ID = t2.ID WHERE t1.ID=1

<?php $date = strtotime("now"); if (date('w', strtotime($date)) == 2 || date('w', strtotime($date)) == 6 ) { echo date_format($date, "Y-m-d"); } else if(date('w', strtotime($date)) < 2) { $nextTuesday = strtotime("this Tuesday"); echo date_format($nextTuesday, "Y-m-d"); } else { $nextSaturday = strtotime("this Saturday"); echo date_format($nextSaturday, "Y-m-d"); } ?>

Declare @user table ( id int, name varchar(20) ) declare @userpermission table ( userid int, permissionid int ) declare @permission table ( id int, name varchar(20) ) create table #userpermissiondetails ( username varchar(20), permissionname varchar(20) ) declare @privileges varchar(max) declare @sql varchar(max) insert into @user values (1,'michael') insert into @user …

Try something like this. DECLARE @UserID INT DECLARE @TempTable TABLE ( FilterID INT ) INSERT INTO @TempTable ( FP.FilterID ) SELECT DISTINCT T.FilterID FROM ( SELECT FP.FilterID FROM BusinessUsers BU INNER JOIN Filter_Parameters FP ON BU.Platform = FP.[Value] AND FP.[Type] = 1 AND BU.ID = @UserID UNION SELECT DISTINCT FP.FilterID …

I don't find any prob with the above one. how about this : ^[0-9]{3,6}[a|m|g]$

When viewed in IE8, my web pages have some alignment issues. Even if I give the CSS style property text-align:center, the text is rendered as left aligned in IE8. Any Solutions??

hi.. i just used my frend's flash drive nd my system got infected.. it shows an error message like "TCP/IP module missing in npqtplugin4.dll.it may be infected by virus" whenever i open firefox .. I used an anti malware nd removed some infections. now firefox working somewhat ok.. but my …

Hi All, I received an e-mail from a friend of mine. It contained three jpeg images with the title Imagens Anexadas. When I tried to open those images,it gave me a dialog box asking either to run or save. I tried to run it.But nothing happened (Nothing am aware of). …

Hi.. Am using response.redirect() to go to another page from the current page. But it is giving me the exception "System.PlatformNotSupported",Operation not supported, change the pipeline mode of IIS. Am working in VS 2008,IIS v5.1 Any Help??

Hi am using sql server 2005.. I hav a query like this. [CODE]create PROCEDURE [dbo].[csp_UpdateAutoPart] ( @Code NVARCHAR(6) ,@Quantity INT ,@UnitPrice DECIMAL ) AS BEGIN -- Update the autopart details UPDATE dbo.AutoPart SET dbo.AutoPart.Quantity = @Quantity ,dbo.AutoPart.UnitPrice = @UnitPrice WHERE dbo.AutoPart.Code = @Code end[/CODE] While executing it, almost 32 rows …

How to clear all the items in the drop down list? [code] DropDownList1.Items.RemoveAt(j); DropDownList1.Items.Clear();[/code] These are not working for me. (am using VC#.net) any help would be appreciated thanks..

can i create dynamic array variable names in php? my requirement is... i want a no: of 1-d arrays like $c1[],$c2[],$c3[]. and i need to dynamically create the arrays like this.. for($i=1;$i<$var;$i++) $c.$i[]=$r; is there any way to do this?

I am using IMG tag to display the graph. In the file(containing the graph code), I check some conditions and if true, then graph is displayed. Otherwise I need to display a warning(using echo). When this IMG tag is used, it is not displayed (obviously). So,is there any way to …

i need to have a hyperlink on the page having the graph code which, when clicked takes me to another page.. what should i do..please help.... thanks in advance.. :)

While using header() to pass values to the file that contains the graph code,the image is not shown. Browser says that it contains some error. Am getting all values passed in the 2nd file, still the graph is not displayed. What could be the reason? Please help...

can we go for ms excel for creating charts in php(with mysql) instead of using jpgraph? please tell me which is the easiest one to use 9between ms excel and jpgraph)?

While creating a horizontal bar graph,the x nd y axes' titles are not displayed proprly. Please do help...

While making the bar graph a horizontal one(JPGraph), am not able to align the axes' titles accordingly.. The titles r not shown parallel to the axes.. Solution PLZZZ..