Thanks again for your time, I truly appreciate it.

Hi,

Firstly, I Apologize for presenting the data the way I did.

I had a very complex situation for doing this and I would truly like to thank you for your help....

CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

davidandrews13 (3/20/2013)

---

are you doing something that a...

Thanks so much for all the help, I really appreciate your time. The select statement seems to be the most risk free ofcourse and works best for me. Cheers!

Chris, thanks again for all the help. Truly thanks doesnt do it but from the bottom of my heart I can not thank you for the help.

Paul, that worked! I dont know how. I am too new to SQL to understand but when I store the data in a table and then run the query it...

That worked great! I did try to run it at my workplace server and got a call in a few minutes from the IT desk to crash the process. 🙂

I...

Ok, that does makes sense.

Just one last question and I am sorry if I am bothering you. How much memory do you anticipate I would need to run the...

Finally ran out of system memory after 1.5 hours. I dont know what to do, this stuff is making me crazy.

Msg 701, Level 17, State 123, Line 3

There is insufficient...

Hi Greg,

I tried quite a lot of advanced functions in SAS. Proc Summary would only summarize fields but I am trying to make all possible filter combinations, which should create...

Yup! Yup! Yup!

This is it. I mean, I will have to do some correlation to find out which variables are not important but thats such a minor give away to...

ok, got it..

Are Rollup and Cube stored procedures because sql doesnt seem to be recognizing them. I am using SQL Server 2005, maybe thats the problem?

I understand, thanks for the help. I will get on it and let you know through this thread if I have a break through. Cheers and thanks again for taking...

Hi,

I understood the issue, it is with the concept. Mathematically, it needs more theories (Permutations, Combinations and Selections) implemented within code, I will have to buy books and read to...