Sorry mate, your sample is very obscure to me and I don't have my Crystal Ball with me today to see what you can see on your site.

Your sample doesn't...

More than happy to help if you follow this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Yes it is possible.

The first thing I would like to advise you when you are gathering statistics in such way is to clean cache before each execution using following command:

DBCC FREEPROCCACHE

Now about...

can you post the code where you set your CommandText in application?

It is an application issue actually, not SQL one.

Somewhere, instead of stored proc name you use variable with value...

shalinder.verma (10/17/2012)

---

Eugene,

Thanks for all the hard work.

First of all, I was comparing the "on the fly tally table" SQL with "Recursive CTE" SQL. Therefore, my phrase "more efficient" should...

shalinder.verma (10/17/2012)

---

Eugene Elutin (10/17/2012)

---

shalinder.verma (10/17/2012)

---

If you are familiar with recursive CTE, you can use following SQL. You won't have to refer to any tables. Moreover this is much more efficient....

Have you checked...

Any proves...

May be the post should read like:

Have I table like a:.... ?

:hehe:

Actually the question is in the post title:

If anyone can help? ...

The answer is: Yes, definitely someone can...

Yes! Partitioning is exactly what you should use. This exactly feature made SQL Server to be one of RDBMS's for Enterprise Size solutions.

I would start from here:

http://msdn.microsoft.com/en-us/library/ms188232(v=sql.105).aspx

...

Here's a typical result;

== iTVF calendar function =========

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 3 ms.

===================================

== calendar table =================

SQL Server...

That is much much more clear. 😉

Now it's kind of:

Go to somewhere, but not there, and I still don't know where....

santoshupadhayay87 (10/16/2012)

---

i want to add three table to the datbase out of which two are from one table and one is of another table can anyone please help me...

There is no in-build "function" to do so, but you can write your own TVF function based on the following:

DECLARE @StartDate DATE = '29 October 2012'

...