Viewing 15 posts - 2,611 through 2,625 (of 3,232 total)
Jeff Moden asks a relevent question in his post. If you answer his questions, you'll get the solution you're after without having to continue this post. I will look for...
October 17, 2006 at 1:22 pm
By the way, Sriram, your suggestion will not work either. Did you try it? It gives syntax errors. If you truely want to go the Dynamic route (again, not suggested),...
October 17, 2006 at 12:54 pm
Since you are concatenating your variables @fromdate and @todate to a string, you need to convert them to a string as well.
And for the third time, you do not...
October 17, 2006 at 12:48 pm
Again, this does not need to be dynamic sql. You say that you are getting an error, what is the error?
October 17, 2006 at 12:38 pm
I see a couple of things just by looking at it, but the most important thing here is that you do not need dynamic SQL to populate your temp table. ...
October 17, 2006 at 9:26 am
I was thinking about using the same approach as Lowel with regards to the derived table using UNION. You did mention that your table is large so you will need...
October 17, 2006 at 8:14 am
How many columns are you talking here? Are they all datetime datatype?
October 16, 2006 at 3:24 pm
I would recommend running your test multiple times and clearing out the buffers and cache in between. I get identical execution times (and execution plans) when I run both of...
October 10, 2006 at 1:45 pm
You cannot reference a variable value as part of a DDL statement. In order to accomplish what you are attempting, you must use Dynamic SQL. Using your example,
declare @townID...
October 10, 2006 at 1:04 pm
Can you post the exact error message along with the DDL for the tables involved in your SELECT?
October 10, 2006 at 12:43 pm
It is generally not recommended to place triggers on the system tables in SQL Server 2000. Therefore, managing stored procedure and DDL changes is a manual process. I would recommend...
October 10, 2006 at 8:22 am
Can you post the function definition for your dbo.wordcount function? Also, post an example of a function call that does not produce the results you are expecting.
October 9, 2006 at 1:13 pm
Ah, you are correct. I appologize for the incorrect info, that's what I get for comming in early today!!
October 5, 2006 at 7:45 am
In addition, while you are in the process of re-writing this, you may want to consider changing your JOIN on the != operator to an ANSI OUTER JOIN as the...
October 5, 2006 at 7:07 am
Can you give a little more detail as far as what you want your result set to look like and which columns do you want min, max, avg? Also, if you've...
October 4, 2006 at 1:47 pm
Viewing 15 posts - 2,611 through 2,625 (of 3,232 total)