Hi, I have a Stored Procedure which in turn calls another Procedure and which in Turn calls another procedures ..... The Problem is Level of Calling...
Hi I want Query for Increase the Table columns Dynamically with the given Date range. For Example, COnsider a Sales table SALES...
I want the <font color="blue">Multiple Row Values </font id="blue"> to be <font color="red">Concatinated </font id="red"> into <font color="blue">One...
I want the Days to be splited into intervals of 90 days between the two given Dates. Like if we Give the dates as '01/01/2006' AND '10/02/2007',...
Hi, I Have Table called Numbers which Contains Columns Num1 and Num2 of same data type. I want a Single Query to swap the rows in the Table. The...
What is @@ Called in @@ERROR?
Can we Encrypt some particular records which of datatype nvacrhar in Table. If not Possible how to store Data in Table in Encrypted format. I'm in...
I have a table MyTable, which has a Column MyColumn of bit data type with default value 1. I want to change the Default value to 0. Thanks in...
<br /><font face="Arial">[blueRecently in an Interview I was asked to write a Query with follwing Criteria][/blue]<br /><br />1. There is a Table...
Hi,<br />Thanks for Taking time to Reply.<br />I have a Search Stored Procedure which uses Dynamic Sql. I'm using "SP_EXECUTESQL" to avoid the SQL...
I'm in Urgent [<img src='/community/emoticons/emotion-11.gif' alt='8)' />] need of Metrics which are considered for the Performance Tuning and...
Separate names with a comma.
