Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]
2006-11-16 (first published: 2004-09-30)
97 reads
Given SQL text (@sql_txt) that will return XML data, run that XML data against an XSL template (@xsl_file_nm), and save the output to the specified outputfile (@out_file_nm). If @xsl_file_nm is not specified, then output is just saved as XML.This script is very usefull, but not secure. One could easily overload any of the script input […]
2004-09-17
274 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...
I have this function, but I wanted to pass a table so as to...
Hi All, I have one task to create a login, and user need to...
Ask SSC