No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
Hi, I Have below table I want all rows with all coloumn from below table where ActCode is 1162828 and sum of DocAmount for DocNo. i.e where the docNo is repeated i want only one row with sum of amount of all repeated rows. ** "Select *, Sum (DocAmount) from … |
|
I am new to php. I am trying to run a loop 5 times. Each time the loop runs I need to run a batch file and test the value of a query. If the query is > 0 exit the loop. Otherwise run a different batch file and continue. … |
|
I have an intranet using php 5.3.8 on Server 2003 using IIS 6.0 and SQL 2005. I run a command to call a batch file that starts and stops sql server and then calls a stored procedure to delete records from a table Items and then refreshes the records from … |