Hi Jeff, Nice to see you here....[:)].....Hope you'll guide us to new concepts of SQL here too... good article...jeff.. Thank you, Sandy.
Hi, what is your real issue? Thank you, Sandy.
Yes, Sure if your report dynamic then you need to use matrix report, thats what the matrix report designed by Microsoft Corp. Matrices A matrix, or...
Please check this; http://weblogs.asp.net/scottgu/archive/2007/06/20/vs-2008-multi-targeting-support.aspx...
Please check this useful article:...
Hi,I think you need to go through replication architecture and why we used replication and concepts. Please find the useful link:...
Hi Danny, 1st of all I want to know what method you type report you are to display the data, Is it tabular or Matrix report? 2nd: Are you using query...
Hi, what exactly you are facing the issue...? Is your error handling part used correctly in your stored procedure? Thank you, Sandy.
Thanks Adriaan, Thank you, Sandy.
hey Chandi, If you go step by step, you can get your result. Let's start with the subquery SELECT fieldx from table2 where key=27, as you said it...
Thanks, 1st Answer: See, one thing I can say you that the use of Like and Full Text Index search are used for different reasons. If the column type...
HI..., Before giving you answer I need one clarification from your end that why are you using both type of search? I mean to say you can use Like Or...
Hi..., what exactly you wants, I mean to say to transfer the table or software installtion problem Thank you, Sandy.
HI, Please check the below links. hope it will help you. 1. http://msdn.microsoft.com/en-us/library/ms152899.aspx 2....
Yes, you can. but I am not sure what exactly you are talking about. (Note: HierarcyId can have a single root only) for your reference you can also...
Atul, Please check your code, you are missing something. I agree with Frank, Thank you, Sandy.
Hi, Please check this: http://blogs.msdn.com/psssql/archive/2008/08/28/sql-server-2008-express-net-framework-2-0-sp2-and-3-5-sp1-explained.aspx Thank...
Please chck this: http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7 Thank you, Sandy.
No, in terms of result but may be you are changing your execution plan structure. But the same execution plan will generate but may be in different...
Dear Seeona, you can check this link: http://www.sqlmag.com/Article/ArticleID/95294/sql_server_95294.html Can you also tell us few question answer as...
Separate names with a comma.
