OK so I have actually got this to a reasonable preformance time.

Using the delimetedsplit8k works great. this issue was with my query:

If you use a derrived table to like...

Ray M (12/19/2012)

---

You can use the matrix, but you need to have the dataset modified.

Add a depenantNum colum and using the rank, or rownumber function number the dependants from 1...

sorry i have resolved this by using a dd in the datepart.

DECLARE @start datetime, @end datetime

SET @start = '1 sep 2011'

SET @end = '4 sep 2011'

SELECT (datediff(dd,@start,@end)/7)+1

This post can be...

Thank you very much,

since the formonth will be a parameter I wrapped the b.ForMonth in an isnull to be able to get a valid date. This has gotten rid...

Hi Yes, sorry, the MemNo 66666 would have all nulls as they do not have any entries in TableB. this is where I am having the problem.

As a word of caution I will warn you that we have explored SCCM where I work and for the resons of it using full sys admin and the fact...

As the_t has mentioned before:

It seems that your network account needs to be an administrator of the server which has the instance installed. If I run SSMS 2005 as my...

Hi,

Has anyone had this problem using a clustered instance? I seem to be ok will all of our other servers apart from this one. I have recently gone to...