Viewing 11 posts - 1 through 11 (of 11 total)
Here it is:
create table table1
(
topicID int,
questionid int
)
create table table2
(
...
October 3, 2011 at 2:03 pm
Hello,
no, actually for the tables you made, since none of the topicID in table 1 have atleast one answer for each questionID in table 2, so the result...
October 3, 2011 at 1:51 pm
Hello, Thanks for the reply. Can you give me an example of how to use Multi-statement table valued function.
Thanks,
Ratan
June 27, 2011 at 2:35 pm
Thanks you all, CTE does not seem to make much difference, but I did some work to optimize the views I have been using, and now it runs a lot...
June 23, 2011 at 3:55 pm
Hello Lutz,
Using a separate table for the view made a difference of about 2 seconds. Why does using a separate table makes...
June 22, 2011 at 3:37 pm
Hello Everybody,
Thanks to toddasd, Kevin and Todd, I was able to come up with a...
June 22, 2011 at 2:38 pm
Can you show me an example as how to store the result set of an inner query to a temp table and then use it. And why does it take...
June 22, 2011 at 2:21 pm
The query performs a lot faster but it does not give the right output. I am going to try to work on it myself. I have also attached some information...
June 21, 2011 at 1:30 pm
Sorry folks for the incomplete information:
Designs:
svCategoryRisk
Column name Data Type Allow Nulls
surveyVersionIDint...
June 21, 2011 at 1:28 pm
Viewing 11 posts - 1 through 11 (of 11 total)