Extra question!

I missed it, but I appreciate it much.

Learned something new.

Thanks

IgorMi

Great question!

Thanks

IgorMi

The answer was easy.

I also appreciate the discussion from SQL Kiwi.

Thanks

IgorMi

The answer was easy.

I also appreciate the discussion from SQL Kiwi.

Thanks

IgorMi

The answer was easy.

I also appreciate the discussion from SQL Kiwi.

Thanks

IgorMi

Thanks for the question

I prefer like this one...

IgorMi

Good one

...[-2147483648,-2147483647, ... ,2147483646,2147483647],[-2147483648,-2147483647, ... ,2147483646,2147483647]...

IgorMi

Hi,

This may help you:

1) Fist try update statistics

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

then try your SP.

2) If no improvement, then try rebuild/reorganize indexes and then update statistics.

http://msdn.microsoft.com/en-us/library/ms189858.aspx

Regards

IgorMi

Hi,

This may help you:

1) Fist try update statistics

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

then try your SP.

2) If no improvement, then try rebuild/reorganize indexes and then update statistics.

http://msdn.microsoft.com/en-us/library/ms189858.aspx

Regards

IgorMi

Hi,

This may help you:

1) Fist try update statistics

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

then try your SP.

2) If no improvement, then try rebuild/reorganize indexes and then update statistics.

http://msdn.microsoft.com/en-us/library/ms189858.aspx

Regards

IgorMi

Thanks for TIES

IgorMi

Hi,

I had similar issue some months ago.

Your description is fine. There are always ways to realize something.

First.

I would like to comment about your DateTable and SiteTable

Why additional...

Hi,

SSIS package may be a best solution.

Regards

IgorMi

Hi,

In your query you can combine the LEN function with RTRIM and LTRIM and...

Hi,

In your query you can combine the LEN function with RTRIM and LTRIM and...