SQL Query and Other
Exporting query results to a CSV or Microsoft Excel spreadsheet file
Exporting query results to a CSV or Microsoft Excel spreadsheet file : Procedure 1. Type your query in the SQL Statements pane of Interactive SQL. 2. At the end of the query, choose on…
Tips
How to format SQL Server dates with FORMAT function
In this article we will look into FORMAT function in SQL Server to format the date and time. Suppose to get DD/MM/YYYY use SELECT FORMAT(getdate(),'dd/MM/yyyy') as date another example MM-DD…
Tips
SQL Server Windows Function
Name Description CUME_DIST Calculate the cumulative distribution of a value in a set of values DENSE_RANK Assign a rank valu…
stored procedure
Stored Procedure in SQL Server
In this article, I will show you how to use a Stored Procedure in SQL. The SQL query we saved as a stored procedure, we can also pass the parameter(s) to a stored procedure so we can execute the stor…
SQL Query and Other
Enable/Disable Transaction Notification for Batch Transaction,Seriail Number and other Documents in SAP Business One
Some times what happen you want to add some notification for those documents where SAP does not provide you an access to write notification query for that like Batch number or Serial Number Window i…
SQL Query and Other
SAP Business One Pre Transaction Notification SQL Query For Various Business Scenario Example
Following are the list of various frequently used notification to block entry in cases, hope these list will help you. ------------------------------------------------------------Block Purchase O…
Social Plugin