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)
95 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
270 reads
At best these phantom backups cause undue headache in troubleshooting. At worst, they make...
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
I’m a creature of habit. I have my routine when I get to my...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Hi, i would like to generate csv file with datetime through sql job with...
--test data declare @T table(a int null, b int null) insert @T(a, b) select...
Ask SSC