MS SQL Server

In Adobe Coldfusion you can only return one record set from using cfquery or queryExecute . If you need to return multiple record sets then you can write a stored procedure and use cfstoredproc .Read →

I was recently tasked with building a complex report. I wrote a SQL Server stored procedure to return the data. It accepts 5 parameters and has complicated logic. It seemed to run fine at first but I…Read →