Nice to see you here....[:)].....Hope you'll guide us to new concepts of SQL here too...
Hi, what is your real issue?
Yes, Sure if your report dynamic then you need to use matrix report, thats what the matrix report designed by Microsoft Corp.
A matrix, or...
Please check this;
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:...
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?
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...
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...
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...
what exactly you wants, I mean to say to transfer the table or software installtion problem
Please check the below links. hope it will help you.
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,
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
Please chck this: http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7
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.