Search Results | SQL Server Performance Forums

I have tried with this code and it seems to me working fine. :eek: select psp_item_no,psp_item_var,sum(psp_qty_prpnl) as Total from...

Thanks for your reply . Plz look my code below : update #temp set #temp.Quantity_mc = a.Total from #temp Inner join ( select...

Thread by: subrata.bauri, Jun 9, 2011, 3 replies, in forum: SQL Server 2008 General Developer Questions

Dear all, I have a simple code (Part of a Procedure) given below : update #temp set #temp.Quantity_mc = a.Total from #temp Inner join (...

Post by: subrata.bauri, Apr 22, 2011 in forum: General Developer Questions

I want to do this thru Code. I want to check that a.no_of_item is already exist in the column no_of_item of the pur_gi_header table. Original Code...

Thread by: subrata.bauri, Apr 22, 2011, 2 replies, in forum: General Developer Questions

Dear Sir, I have written a INSERT Trigger to insert records from Table1(Col1,Col2) to Table2 (Col1,Col2). I want to prevent duplicate value to...

Thread by: subrata.bauri, Jul 22, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Dear All, How to apply the SP 2 on existing SQL Server 2005 ? How can I verify that SP2 has ben applied or not ? Kindly reply .

Post by: subrata.bauri, Mar 11, 2009 in forum: Getting Started

Thanks to all.

Thread by: subrata.bauri, Mar 9, 2009, 3 replies, in forum: Getting Started

Dear All, I'm Subrata Bauri, I live in India. Now working as a Technical Consultant in Microsoft Dynamics NAV at Limtex Infotech Ltd. that's...

Thread by: subrata.bauri, Mar 9, 2009, 5 replies, in forum: Getting Started

Hi All, Iâ€™m not getting any error message during MS SQL Server 2008 Installation on the Windows XP SP3 system. I want to know from you that are...