I have a SQL 2008 database and I call a stored procedure from C# code. The SP called inside him called other SP which return recordset. Look on the pic. the result of execution.
The question is: how to avoid returning back to C# code the first result ? I guess I change the SP and pass a value that tell to embed SP to not return data, but is there a other way? D--Temp-Untitled.png
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.