SQLServerCentral / Database Design / Design Ideas and Questions / How to design new query to take off invoice? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 08:54:59 GMT20RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspx[quote][b]kichravishankar1 (9/8/2010)[/b][hr]Printing Invoice in Different Design in Tally ERP 9:[/quote]What is this? ;-)Wed, 08 Sep 2010 04:12:26 GMTMadhivanan-208264RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxPrinting Invoice in Different Design in Tally ERP 9:Wed, 08 Sep 2010 04:03:15 GMTkichravishankar1RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxFrom my report If this code "AS0630" tell me the person had they money back. I am only looking for people who have not receive they money back.LakhTue, 30 Dec 2008 07:46:29 GMTLakhbir.BhattiRE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspx[quote]SELECT *FROM dbo_pod_surgeryWHERE phc_id="22/15729"; [/quote]If you know activity why r u using phc_id... you can directly use the activity in where clause.Tue, 30 Dec 2008 07:36:55 GMTbrainyRE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxHi Madhivanan,This is my query see below.Please can you add the missing part for me. i am having erorro message.SELECT *FROM dbo_pod_surgeryWHERE phc_id="22/15729"; LakhTue, 30 Dec 2008 07:21:55 GMTLakhbir.BhattiRE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspx[quote][b]Lakhbir.Bhatti (12/30/2008)[/b][hr]ThanksLakh[/quote]You are welcome :)Tue, 30 Dec 2008 06:51:34 GMTMadhivanan-208264RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxThanksLakhTue, 30 Dec 2008 06:42:50 GMTLakhbir.BhattiRE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspx[quote][b]Lakhbir.Bhatti (12/30/2008)[/b][hr]If any invoices matching to code AS0630 that showing me the invoices are paid and take it off my list.[/quote]select * from table as twhere not exists(select * from table where invoiceno=t.invoiceno and activity='AS0630')Tue, 30 Dec 2008 06:07:19 GMTMadhivanan-208264RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxIf any invoices matching to code AS0630 that showing me the invoices are paid and take it off my list.Tue, 30 Dec 2008 05:50:46 GMTLakhbir.BhattiRE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxDo you want one row per invoice?Tue, 30 Dec 2008 05:37:17 GMTMadhivanan-208264RE: How to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxYou have 2 activity columns... what are they really called?And please... not nice to double post.Tue, 30 Dec 2008 05:09:52 GMTJeff ModenHow to design new query to take off invoice?http://www.sqlservercentral.com/Forums/Topic627219-373-1.aspxInvoice Date activity activity activity location 102 14-Mar-06 A SS80 SS70 L20.POD 102 24-Jul-06 A SS78 L20.POD 102 21-Aug-06 A AS0630 L15.PS 102 25-Aug-06 A SS71 L20.POD 102 01-Sep-06 A SS76 L20.POD 102 21-Nov-06 A SS74 L20.POD 105 25-Aug-06 A SS71 L20.POD 106 01-Sep-06 A SS76 L20.POD 107 21-Nov-06 A SS74 L20.PODHow to take off Invoice 102=AS0630 and keep invoice 105,106 and 107.LakhTue, 30 Dec 2008 04:45:42 GMTLakhbir.Bhatti