Click here to Skip to main content
15,075,944 members

Comments by Raja Sekhar S (Top 200 by date)

Raja Sekhar S 13-Mar-14 2:25am View
   
Provide table Structure with some sample data..
Raja Sekhar S 15-Dec-13 23:31pm View
   
Provide some sample data... u can use find function...
Raja Sekhar S 4-Dec-13 23:05pm View
   
i thought it was sql.. thanks for reminding mr.. deleting the ans..
Raja Sekhar S 2-Dec-13 2:54am View
   
Nice one.. +5!
Raja Sekhar S 25-Nov-13 2:05am View
   
Do you want to read data from Notepad and save it in excel...?
Raja Sekhar S 14-Nov-13 23:00pm View
   
As usual nice one Maciej Los.... +5!
Raja Sekhar S 29-Oct-13 0:21am View
   
Nice one... +5!
Raja Sekhar S 29-Oct-13 0:16am View
   
Thank you... Amol_B
Raja Sekhar S 28-Oct-13 7:50am View
   
Check the Updated Solution...
Raja Sekhar S 24-Oct-13 1:09am View
   
This one Works for Oracle.... not for Sql Server
Raja Sekhar S 23-Oct-13 4:10am View
   
Can you post Your Sql Query...?
Raja Sekhar S 4-Oct-13 8:21am View
   
Did it Solved Your Problem...?
Raja Sekhar S 4-Oct-13 2:55am View
   
Provide Sample input and Output...
Raja Sekhar S 1-Oct-13 5:16am View
   
It will show the data present in Columns Id,FirstName,Surname From Table 'tblContacts' in AddressBook.mdb Ms-Access File Located in C: Location
Raja Sekhar S 30-Sep-13 5:31am View
   
Did you got what you are looking for..?
Raja Sekhar S 30-Sep-13 4:22am View
   
Did it solve your problem..?
Raja Sekhar S 27-Sep-13 7:32am View
   
To allow OLEDB Connection Use this..
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1;
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1;
GO
Raja Sekhar S 27-Sep-13 2:36am View
   
Nice..+5!
Raja Sekhar S 26-Sep-13 7:06am View
   
Thank you...
Raja Sekhar S 26-Sep-13 6:15am View
   
Thank you...
Raja Sekhar S 26-Sep-13 5:53am View
   
Nice one Maciej Los... +5!
Raja Sekhar S 26-Sep-13 5:52am View
   
Deleted
Nice one Maciej Los... +5!
Raja Sekhar S 26-Sep-13 5:42am View
   
Glad to help.... if it solved your problem... mark it as answer....
Raja Sekhar S 26-Sep-13 4:05am View
   
Did it Solve your Problem..?
Raja Sekhar S 26-Sep-13 3:43am View
   
use this

Exec sp_configure 'show advanced options', 1;
RECONFIGURE;
GO

Exec sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1
GO

SELECT Sno,Data,Row_Number() Over (Order by Sno) as AutoNumber into #XLImport1
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;HDR=YES;Database=C:\test.xlsx','SELECT * FROM [Sheet1$]');

Select * FROM #XLImport1
Drop Table #XLImport1

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 0
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 0
GO

Exec sp_configure 'Ad Hoc Distributed Queries', 0;
RECONFIGURE;
GO

Exec sp_configure 'show advanced options', 0
RECONFIGURE;
GO
Raja Sekhar S 26-Sep-13 3:41am View
   
sorry u have to use Single quotes.. Check the Updated Solution
Raja Sekhar S 26-Sep-13 3:23am View
   
Thats why i have given queries for enabling adhoc queries use my tested code...
Raja Sekhar S 26-Sep-13 2:16am View
   
Thank you....
Raja Sekhar S 26-Sep-13 1:10am View
   
@P_Opp is a variable, not a column in a table. so use ADMN_SCREENROLERIGHTS.P_Opp = 1 or if you are passing a column Name through that variable use a Dynamic Query...
Raja Sekhar S 21-Sep-13 1:07am View
   
Nice one ...+5!
Raja Sekhar S 20-Sep-13 8:47am View
   
if it solved your problem mark it as answer...
Raja Sekhar S 20-Sep-13 8:16am View
   
Did it solve your Problem..?
Raja Sekhar S 20-Sep-13 8:02am View
   
u got what you are looking for..?
Raja Sekhar S 20-Sep-13 7:24am View
   
Nice one..+5!
Raja Sekhar S 20-Sep-13 6:51am View
   
Is this Your Question...
Select People present in first table and not in second table..?
Customer and Calls are different tables... or it is a single table..?
Raja Sekhar S 20-Sep-13 5:49am View
   
Thank you Prabhu...
Raja Sekhar S 20-Sep-13 5:01am View
   
In your Query for each and every value the select count(*) will be executed... if there are 10 records in that table... select count(*) will run for 10 times... and if the sno is not Order wise then also some issues will arise...
Raja Sekhar S 20-Sep-13 4:38am View
   
Nice one... +5!
Raja Sekhar S 20-Sep-13 4:26am View
   
Deleted
Do u want to pick data from a TABLE in a database...?
Can u be more Specific....
Raja Sekhar S 20-Sep-13 4:24am View
   
Thank you Rakesh...
Raja Sekhar S 20-Sep-13 4:18am View
   
Thank you Maciej Los....
Raja Sekhar S 18-Sep-13 0:17am View
   
Nice.. Forgot about Pivot... +5!
Raja Sekhar S 17-Sep-13 7:42am View
   
No other way as of i know... if it answered your question mark it as answer...
Raja Sekhar S 17-Sep-13 7:31am View
   
I think it's not possible.... any one correct me if am wrong...
is there any reason for you to not use dynamic Query..?
Raja Sekhar S 14-Sep-13 2:38am View
   
You are welcome...
Raja Sekhar S 12-Sep-13 1:17am View
   
as RedDk told.... the sample data which u gave and output from the procedure didn't add up... so clearly specify what u want... Give sample i/p and output..
so we can help...
Raja Sekhar S 11-Sep-13 3:44am View
   
what will be the output for this data...?
Raja Sekhar S 11-Sep-13 3:13am View
   
Provide some sample data of the table...
Raja Sekhar S 11-Sep-13 2:54am View
   
What is ID and EmpId..? both are same..? in Cursor you are using EmpId, for calculating SumMinutes you are using Id. Provide some sample data...
Raja Sekhar S 11-Sep-13 2:38am View
   
Deleted
Provide Some Sample Data....
Raja Sekhar S 11-Sep-13 2:33am View
   
+5!
Raja Sekhar S 10-Sep-13 8:14am View
   
after modifying run the script(F5)....
Raja Sekhar S 7-Sep-13 0:51am View
   
Really.... i got it... u haven't checked the solution....
Raja Sekhar S 6-Sep-13 7:22am View
   
is it working...?
Raja Sekhar S 6-Sep-13 6:47am View
   
Check the Updated Solution...
Raja Sekhar S 6-Sep-13 4:12am View
   
Check the updated solution...
Raja Sekhar S 6-Sep-13 4:02am View
   
In the solution which i have given,in the cursor u can use the select statement...
Check the links which i provided, you will get an idea on how to do it... your answer to my question states that you are entirely new to sql...
Raja Sekhar S 6-Sep-13 3:52am View
   
Can u specify the table structure.. u saved column names as rows or comma seperated value...?
Raja Sekhar S 6-Sep-13 3:37am View
   
Check the Updated Solution...
Raja Sekhar S 6-Sep-13 3:30am View
   
+5!
Raja Sekhar S 3-Sep-13 3:41am View
   
u can use where Column_name='columnName' and Table_name='TableName'
Raja Sekhar S 3-Sep-13 3:31am View
   
+5!
Raja Sekhar S 3-Sep-13 3:24am View
   
Glad to help....
Raja Sekhar S 3-Sep-13 0:52am View
   
Thank you...
Raja Sekhar S 3-Sep-13 0:52am View
   
Thanks...
Raja Sekhar S 2-Sep-13 6:55am View
   
Did it Solve your Problem...?
Raja Sekhar S 30-Aug-13 2:43am View
   
Did it help..?
Raja Sekhar S 29-Aug-13 8:50am View
   
Thank you Zoltan Zorgo....
Raja Sekhar S 29-Aug-13 4:00am View
   
Did it solve the Problem..?
Raja Sekhar S 28-Aug-13 7:53am View
   
In the Query which i Wrote it is Grouping Based on Machine Type..u Can see the sample Output Showing only one Record for Machine Type... u can even add some Sample Data to the above Query and check the output...
If not please Specify your Table Structures, Keys...
Raja Sekhar S 28-Aug-13 7:50am View
   
Deleted
In the Query which i Wrote it is Grouping Based on Machine Type..u Can see the sample Output Showing only one Record for Machine Type... u can even add some Sample Data to the above Query and check the output...
If not please Specify your Table Structures, Keys...
Raja Sekhar S 28-Aug-13 7:33am View
   
Is Permission required to read and write Data in the sheet..?
Raja Sekhar S 28-Aug-13 7:29am View
   
Have u checked Excel File name and Sheet Name typed Correctly..?
Raja Sekhar S 28-Aug-13 7:17am View
   
Did u installed all drivers for that...?
Raja Sekhar S 28-Aug-13 3:42am View
   
The no of Begin and End do not match... You Have to Add a Begin after if @ch=1 or Remove End
Raja Sekhar S 27-Aug-13 2:27am View
   
You are Welcome...
Raja Sekhar S 27-Aug-13 0:56am View
   
I think for 2010 we have to use Microsoft.ACE.OLEDB.12.0 and Excel 12.0..Correct me if i am wrong... Check with this once...
Raja Sekhar S 26-Aug-13 8:07am View
   
Glad to help...
Raja Sekhar S 26-Aug-13 8:06am View
   
Which version of excel you are using.....?
Raja Sekhar S 26-Aug-13 7:58am View
   
Thank you.....
Raja Sekhar S 8-Aug-13 5:40am View
   
The Error itself Clearly Explains What the Problem is... So Check the Column Name...
Raja Sekhar S 8-Aug-13 0:46am View
   
+5!
Raja Sekhar S 7-Aug-13 2:55am View
   
Nice one..+5!
Raja Sekhar S 6-Aug-13 2:20am View
   
You are Welcome...
Raja Sekhar S 6-Aug-13 1:25am View
   
Nice.. +5!
Raja Sekhar S 5-Aug-13 3:27am View
   
Nice Links..
+5!
Raja Sekhar S 5-Aug-13 3:05am View
   
Thank you maciej los...
Raja Sekhar S 5-Aug-13 3:01am View
   
Sorry.. Thought it was SqlServer, Deleting the answer... I think i have removed the filter for answers...
Raja Sekhar S 5-Aug-13 2:56am View
   
Th output will be only records of 253 as 1234 has sensor id 3... if u want to use for only one day... Check my Updated Solution...
Raja Sekhar S 2-Aug-13 2:33am View
   
True.. Agree... But For beginners like us we can't Directly Jump into ADODB Recordset and all the Stuff so we do like this and try to learn the Advanced Topics...
Raja Sekhar S 2-Aug-13 2:15am View
   
Nice One... +5!
Raja Sekhar S 2-Aug-13 1:08am View
   
Can you Post the Code and table Structure too.. so that we can help... Use Improve Question Widget...
Raja Sekhar S 2-Aug-13 1:01am View
   
If SET ARITHABORT OFF Then Null Value is Assigned to the Column When Divide by Zero Error Occur.. so if u are Using Aggregate Function on a column where Divide by Zero Error Occurs.. this Warning will come...
Raja Sekhar S 1-Aug-13 8:22am View
   
You are Welcome... Glad to Help...
Raja Sekhar S 1-Aug-13 8:09am View
   
Got it.. Thank You...
Raja Sekhar S 1-Aug-13 8:00am View
   
Thanks.....
Raja Sekhar S 1-Aug-13 7:56am View
   
Struggling with it since i posted...
Raja Sekhar S 1-Aug-13 7:49am View
   
yes... It Worked What's Wrong With the Brackets..?
+5!
Raja Sekhar S 1-Aug-13 7:40am View
   
Is there any Divide by Zero Error Occuring..? if that is the Case u Can Use SET ARITHABORT OFF
Raja Sekhar S 1-Aug-13 7:37am View
   
Nice One Maciej Los... I was Updating my Solution with Modulo Operator and Saw your Solution...
I have a Doubt Maciej Los.. If i Use the Update Statement which i wrote it works But if i change this
Salary + ( Salary *Id* 0.05 ) to
Salary + ( Salary *Id* (5/100) ) the Update Statement Won't Work,
If i Use Salary + ( (Salary/100) *Id * 5 ) ) again it Works.. Why..?
Raja Sekhar S 1-Aug-13 7:11am View
   
Thanks Adarsh... It seems he was doing his part of work (See his Profile page)... So wrote the Solution...
Raja Sekhar S 1-Aug-13 4:42am View
   
+5!
Raja Sekhar S 1-Aug-13 3:42am View
   
What are the Primary Columns...?
Raja Sekhar S 1-Aug-13 3:30am View
   
Can you Post the Code..?
Raja Sekhar S 1-Aug-13 3:17am View
   
You may be correct Maciej Los. i will Provide some links for his Learning..
Raja Sekhar S 1-Aug-13 2:40am View
   
Thank you... Adarsh...
Raja Sekhar S 1-Aug-13 2:39am View
   
You are welcome... Glad to Help...
Raja Sekhar S 1-Aug-13 2:25am View
   
Nice Links.... +5!
Raja Sekhar S 31-Jul-13 7:59am View
   
Thank you Adarsh...
Raja Sekhar S 31-Jul-13 7:51am View
   
In that case if u give @Specality variable as Null it will automatically come...
Raja Sekhar S 31-Jul-13 7:50am View
   
Thank You Adarsh...
Raja Sekhar S 31-Jul-13 7:46am View
   
You are Welcome...
Raja Sekhar S 31-Jul-13 7:46am View
   
If there are Records Present Then u will get the records...
Raja Sekhar S 31-Jul-13 7:46am View
   
You cannot use like isnull(@Name,name)%
but while assigning the variable itself u can use @Name ='T%'
Raja Sekhar S 31-Jul-13 7:43am View
   
Deleted
If there are Records Present Then u will get the records...
Raja Sekhar S 31-Jul-13 7:38am View
   
Nice.. +5!
Raja Sekhar S 31-Jul-13 6:30am View
   
I Think that's not possible... Thanks again...
Raja Sekhar S 31-Jul-13 6:01am View
   
If you Use FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, '')
the First Letter will get Terminated... so we have to Use...
FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 0, '')
Raja Sekhar S 31-Jul-13 5:59am View
   
Thank you Maciej Los...
Raja Sekhar S 30-Jul-13 7:25am View
   
Don't Use Table Variable instead use temporary table..
Raja Sekhar S 30-Jul-13 6:10am View
   
Check the Updated Solution....
Raja Sekhar S 30-Jul-13 4:45am View
   
Can u Post the Query u used...?
Raja Sekhar S 30-Jul-13 4:08am View
   
Thanks Maciej Los!....
Raja Sekhar S 30-Jul-13 4:08am View
   
Can u Post the Query Which u Used..?
Raja Sekhar S 30-Jul-13 2:47am View
   
Thank You... Adarsh..
Raja Sekhar S 29-Jul-13 7:51am View
   
You are Welcome...
Raja Sekhar S 29-Jul-13 7:48am View
   
You are Welcome... Nice Solution +5!
Raja Sekhar S 29-Jul-13 7:44am View
   
If Data Base Collation is Case Sensitive then u have to Use Upper Case...
INFORMATION_SCHEMA.PARAMETERS or else Error will come..
Raja Sekhar S 29-Jul-13 7:11am View
   
Do you Know what is the Problem when u use Case Statement in Select Query... U have to Hard-Code the Column Name... so i suggest u use if statement or a Dynamic Query...
Raja Sekhar S 29-Jul-13 7:08am View
   
Nice one... +5!
Raja Sekhar S 29-Jul-13 7:07am View
   
in that case i Suggest u use Maciej Los Solution...
Raja Sekhar S 29-Jul-13 3:58am View
   
You are Welcome...
Raja Sekhar S 29-Jul-13 3:33am View
   
Nice one... +5!
Raja Sekhar S 29-Jul-13 3:20am View
   
Check the Updated Solution..
Raja Sekhar S 29-Jul-13 3:03am View
   
Check the Updated Solution...
Raja Sekhar S 29-Jul-13 2:56am View
   
In that case u can write if statement or case statement...
First u have to be clear about how many parameters you have to pass to the procedure.. then based on that we can write if or case statements...
Tell me ur requirement exactly.. How many parameters you want to pass and what are optional parameters and what is the op required... use Improve Question widget...
Raja Sekhar S 29-Jul-13 2:41am View
   
U can use the select Statement in the Procedure....
Raja Sekhar S 26-Jul-13 7:57am View
   
In Web.config to change the timeout for one specific page:
<location path="somefile.aspx">
<system.web>
<httpruntime executiontimeout="180">



or
<httpruntime maxrequestlength="2097152" executiontimeout="600">
Check this links:
https://www.google.co.in/search?q=increase+timeout+in+web.config&oq=increase+time+out+&aqs=chrome.3.69i57j0l3.8890j0&sourceid=chrome&ie=UTF-8
Raja Sekhar S 26-Jul-13 7:11am View
   
You are Welcome....
Raja Sekhar S 26-Jul-13 6:24am View
   
There will be a .config file in your application files... some thing like app.exe.config.. in that there will be something like Processing time out
just increase the value... Don't Forget to take a backup of that config file before making any changes...
Raja Sekhar S 26-Jul-13 6:14am View
   
U can Increase the timeout of your Application...
Raja Sekhar S 26-Jul-13 6:11am View
   
As usual... Nice Links Maciej Los.... +5!
Raja Sekhar S 26-Jul-13 6:11am View
   
U can change the Set Statement to this..
Select @lat=Lat,@Long=Long from Cities where Zip=@Zip..
But there won't be too much improvement in the Query Execution... it can be due to many issues.. u have to check the Links Provided by Maciej Los in his Answer...
Raja Sekhar S 26-Jul-13 5:29am View
   
Remove Distinct in "select Distinct GroupID From"
Raja Sekhar S 26-Jul-13 3:47am View
   
Thank you...
Raja Sekhar S 26-Jul-13 3:45am View
   
But op wanted the time along with AM/PM... That's why i used the Right Function.. Other wise i would have suggested Time.....
Raja Sekhar S 26-Jul-13 3:17am View
   
Either you can increase the timeout Limit in application or u can improve the Stored Procedure Performance... Previously encountered the same issue...
Raja Sekhar S 26-Jul-13 3:16am View
   
Deleted
Either you can increase the timeout Limit in application or u can improve the Stored Procedure Performance... Previously encountered the same issue...
Raja Sekhar S 26-Jul-13 3:12am View
   
Maciej Los: Thanks for the Suggestion.. Updated the solution....
Raja Sekhar S 25-Jul-13 5:35am View
   
Nice one... +5!
Raja Sekhar S 25-Jul-13 3:04am View
   
u got what u wanted..?
Raja Sekhar S 25-Jul-13 2:15am View
   
Agree.. +5!
Raja Sekhar S 25-Jul-13 2:13am View
   
Deleted
Agree.....+5!
Raja Sekhar S 25-Jul-13 1:54am View
   
Why are you using isnull(@user_id,NULL)..? The Purpose of isnull is to return some value if the variable is null... so if u use this isnull(var,Null) u are asking sql server to return null if var is null..u will again encounter the error "The 'insert_loginDetails' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead".

You Should use isnull while assigning value to @user_id like
select @user_id=isnull(@@Identity,0/*non null value like 0*/) from user login

While Writing if statements or begin end statements u have to give some space between code blocks so anyone can understand what part of code belongs to which if statement. Code Readability...

mark my amswer as solution if it helped...
Raja Sekhar S 24-Jul-13 2:40am View
   
What are the parameters you are planning for the Stored Procedure..?
Raja Sekhar S 23-Jul-13 3:46am View
   
Glad to Help...
Raja Sekhar S 22-Jul-13 5:54am View
   
Check the Updated solution and let me know....
Raja Sekhar S 22-Jul-13 5:25am View
   
Same error..?
Raja Sekhar S 18-Jul-13 3:38am View
   
You cannot add comment as a Solution.....
so add it as a comment and delete it as solution....
if u got the solution... accept it as answer...
Raja Sekhar S 18-Jul-13 1:05am View
   
In the Place of Sheet1 or SheetName Type the Sheet Name of the Excel......
Like In a Excel File Testing.xls there will be many sheets like sheet1,sheet2 so on... so give the name of the sheet to which u want to export..U can use Where dbo.vwRCHeadDetails.RCDate Between @Fdate and @TDate...(Assuming @Tdate is Greater than @Fdate).. Refer the Link Which i provided in the Solution.....
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Raja Sekhar S 18-Jul-13 0:54am View
   
You are Welcome...
Raja Sekhar S 17-Jul-13 8:04am View
   
You are welcome...
Raja Sekhar S 17-Jul-13 6:25am View
   
U can update that....
Raja Sekhar S 17-Jul-13 6:03am View
   
@Vehbi Neziri:
i think you forgot to set @Return_Code=0 after insert statement....
Raja Sekhar S 17-Jul-13 5:46am View
   
You are welcome......
Raja Sekhar S 17-Jul-13 4:27am View
   
Sure... am not the one who DownVoted it...
Raja Sekhar S 17-Jul-13 4:11am View
   
@Tadit Dash...
If SectionId is PrimaryKey Then your Query will Throw an error..
Because PrimaryKey Columns won't allow nulls...
Refer this Link: http://msdn.microsoft.com/en-us/library/ms189039.aspx
Raja Sekhar S 17-Jul-13 3:53am View
   
You are encountering this error because.. you are trying to insert a duplicate value into the Primary key column of the table.... Provide the MetaData of the table... or in that
IF EXISTS statement u can use the statement based on Primary key column... like
If exists(Select * from TableName Where Primarycolumnvalue=@Param).
If that exists statement should not be changed.... then Provide the details of the table so we can help...
Raja Sekhar S 17-Jul-13 3:44am View
   
It's Running Fine in Sql Server 2012.... Check whether you are running in Sql server 2012 or lower version...
Raja Sekhar S 17-Jul-13 3:14am View
   
Thanks Bernhard Hiller...
There is no sample data.. so i assumed it...
Raja Sekhar S 17-Jul-13 1:16am View
   
Check the Solution... I Have Updated it.... make sure all the columns are Named....
Raja Sekhar S 16-Jul-13 8:07am View
   
You are Welcome....
Raja Sekhar S 16-Jul-13 8:07am View
   
In that Case Select all Required Columns and use Full Outer Join....
Raja Sekhar S 16-Jul-13 7:43am View
   
Can you Provide an Example... use Improve Question Widget...
Raja Sekhar S 16-Jul-13 7:40am View
   
In that Case Select all Required Columns and use Full Outer Join....
Can u explain What do u mean by Hierarchical Flow Here...?
Raja Sekhar S 16-Jul-13 7:26am View
   
Remove Where Statement in your Query it will work for entire table....
Raja Sekhar S 16-Jul-13 7:22am View
   
You are Welcome...
Raja Sekhar S 16-Jul-13 6:36am View
   
What is the Relation Between two tables..?
Raja Sekhar S 16-Jul-13 4:39am View
   
The Error is simple... check this link...
http://msdn.microsoft.com/en-us/library/ms177673.aspx..
U Can use Group by PartyName,ContenderName or if only one candidate exists for a Party.. u can use min(PartyName) and Group by ContendentName
Raja Sekhar S 16-Jul-13 4:02am View
   
Nice one... +5..!
Raja Sekhar S 16-Jul-13 3:58am View
   
Provide some Sample Data... use Improve Question Widget... Be Specific...
Raja Sekhar S 10-Jul-13 5:35am View
   
What exactly do u want to insert..? Use the Improve Question Widget....
Raja Sekhar S 10-Jul-13 1:28am View
   
Yep...
Raja Sekhar S 10-Jul-13 1:27am View
   
Use Improve Question Widget.... Provide an example or make it clear....
Raja Sekhar S 10-Jul-13 1:16am View
   
Good one... +5..!
Raja Sekhar S 10-Jul-13 1:14am View
   
Thank You _Damian S_...
Raja Sekhar S 10-Jul-13 0:56am View
   
No, In Transact-SQL, each TRY block is associated with only one CATCH block.
Refer to this link:
http://msdn.microsoft.com/en-us/library/ms179296(v=sql.105).aspx
Raja Sekhar S 9-Jul-13 4:07am View
   
You are Welcome.... if the answer is helpful... u can accept it as Answer...
Raja Sekhar S 9-Jul-13 4:04am View
   
May be updating is taking some time..... You are welcome...
Raja Sekhar S 9-Jul-13 4:03am View
   
U can see it....
Raja Sekhar S 9-Jul-13 4:02am View
   
Thank You....
Raja Sekhar S 9-Jul-13 3:53am View
   
Thank you.. Maciej Los...
Raja Sekhar S 9-Jul-13 3:51am View
   
Rupai99...
Don't Post same Question again and again...
http://www.codeproject.com/Questions/617623/Referencing-a-data-field-in-two-columns-based-on-c
Raja Sekhar S 9-Jul-13 3:48am View
   
Agree..... i Completely forgot this in the answer which i posted....
nice one.... +5..! Maciej Los....
Raja Sekhar S 9-Jul-13 3:38am View
   
You are Welcome...
Raja Sekhar S 9-Jul-13 3:38am View
   
Thank you, Maciej Los..
Raja Sekhar S 9-Jul-13 3:29am View
   
Good one.... +5..!
Raja Sekhar S 9-Jul-13 3:21am View
   
@Maciej Los: As always nice answer...
+5..!
Raja Sekhar S 9-Jul-13 3:20am View
   
In that Case in the cte u can use "Where" Clause to select the Items you Require... so based on items top 5 records will be displayed....
Raja Sekhar S 4-Jul-13 0:52am View
   
Thank You...
+5!