<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blog.4penny.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Server (T-SQL) - All Comments</title><link>http://blog.4penny.net/blogs/sqlserver/default.aspx</link><description>Comments and notes on SQL Server 2000, 2005, and T-SQL</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP2 (Build: 20611.960)</generator><item><title>re: Creating a Stored Procedure with OUTPUT Parameters</title><link>http://blog.4penny.net/blogs/sqlserver/archive/2007/04/20/creating-a-stored-procedure-with-output-parameters.aspx#1133</link><pubDate>Fri, 11 Jul 2008 10:22:30 GMT</pubDate><guid isPermaLink="false">05d3ee43-09e1-4c21-9d53-64ecaf1acc4f:1133</guid><dc:creator>asif</dc:creator><description>&lt;p&gt;thx buddy this helped me lot&lt;/p&gt;
&lt;img src="http://blog.4penny.net/aggbug.aspx?PostID=1133" width="1" height="1"&gt;&lt;br /&gt;&lt;div style="border : 1px solid #666666;"&gt;&lt;p&gt;This Comment is currently Published.&lt;br /&gt;The spam blocker rated it as NotProcessed with a score of 0.&lt;/p&gt;&lt;p&gt;You can control the status of this comment with the links below.&lt;br /&gt;&lt;a href="http://blog.4penny.net/blogs/sqlserver/archive/2007/04/20/creating-a-stored-procedure-with-output-parameters.aspx#1133"&gt;View&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=moderate&amp;postids=1133"&gt;Unpublish&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=delete&amp;postids=1133"&gt;Delete&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</description></item><item><title>re: Writing to a Text File with SQL Server 2000</title><link>http://blog.4penny.net/blogs/sqlserver/archive/2007/03/23/writing-to-a-text-file-with-sql-server-2000.aspx#1095</link><pubDate>Tue, 24 Jun 2008 10:56:40 GMT</pubDate><guid isPermaLink="false">05d3ee43-09e1-4c21-9d53-64ecaf1acc4f:1095</guid><dc:creator>james</dc:creator><description>&lt;p&gt;awesome - just what I was looking for - thanks; &lt;/p&gt;
&lt;img src="http://blog.4penny.net/aggbug.aspx?PostID=1095" width="1" height="1"&gt;&lt;br /&gt;&lt;div style="border : 1px solid #666666;"&gt;&lt;p&gt;This Comment is currently Published.&lt;br /&gt;The spam blocker rated it as NotProcessed with a score of 0.&lt;/p&gt;&lt;p&gt;You can control the status of this comment with the links below.&lt;br /&gt;&lt;a href="http://blog.4penny.net/blogs/sqlserver/archive/2007/03/23/writing-to-a-text-file-with-sql-server-2000.aspx#1095"&gt;View&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=moderate&amp;postids=1095"&gt;Unpublish&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=delete&amp;postids=1095"&gt;Delete&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</description></item><item><title>re: Mail from a stored procedure in SQL 2005</title><link>http://blog.4penny.net/blogs/sqlserver/archive/2007/02/02/mail-from-a-stored-procedure-in-sql-2005.aspx#1065</link><pubDate>Fri, 13 Jun 2008 17:09:57 GMT</pubDate><guid isPermaLink="false">05d3ee43-09e1-4c21-9d53-64ecaf1acc4f:1065</guid><dc:creator>Patty</dc:creator><description>&lt;p&gt;I know this is an old post but I do not see the answer to Srinivis's comment.&lt;/p&gt;
&lt;p&gt;I have the same problem - would like to execute a custom stored proc &amp;nbsp;with params IN the cb_sp_send_dbmail.&lt;/p&gt;
&lt;p&gt;Do you know the syntax?&lt;/p&gt;
&lt;img src="http://blog.4penny.net/aggbug.aspx?PostID=1065" width="1" height="1"&gt;&lt;br /&gt;&lt;div style="border : 1px solid #666666;"&gt;&lt;p&gt;This Comment is currently Published.&lt;br /&gt;The spam blocker rated it as NotProcessed with a score of 0.&lt;/p&gt;&lt;p&gt;You can control the status of this comment with the links below.&lt;br /&gt;&lt;a href="http://blog.4penny.net/blogs/sqlserver/archive/2007/02/02/mail-from-a-stored-procedure-in-sql-2005.aspx#1065"&gt;View&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=moderate&amp;postids=1065"&gt;Unpublish&lt;/a&gt; &amp;nbsp;|&amp;nbsp; &lt;a href="http://blog.4penny.net/controlpanel/blogs/comments.aspx?sectionid=9&amp;action=delete&amp;postids=1065"&gt;Delete&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</description></item></channel></rss>