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 started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...
Hi All, I've got a nasty column that I need to get the name...
I'm struggling a bit here. It seems easy, but I 'm not getting it....
Ask SSC