Is this the only work around? I was hoping for something more straight forward, maybe I'm just expecting too much. This kinda complicates the "All" option as well as it...

Wow this is amazing, and I just finished telling my boss I would have too much trouble parsing a comma delimited string using SQL and that the front end guy...

I figured it out! Thank god, sorry I burdened you with this, sometimes I just need to think...

So I guess its easy to see if a protection factor doesnt exist at all, you would just get back a null. The real problem is when multiple protection factors...

Thanks for the links, I'm slowly understanding this stuff. Though I do find books online to be a rather difficult source of information to understand. I would rather get a...

Lowell, are you saying that you would join your imported data to a view to get the appropriate values, and then place it into the staging table?

Ideally this is...

Ya we are working with SQL Server 2005 Express edition, so there is no SSIS available. Besides, we are trying to create a univseral style of solution that we can...

I found the answer after hours of looking on the internet, and trying to figure out whats going on with this whole FMTONLY thing. It turns out that FMTONLY is...

After looking more into this, I almost wonder if it is something I should be getting the report to be doing. This is for a report after all, but I'm...

Tried the above mentioned solution already, it doesn't help.

I am pretty much just interested in a record and it associated 'TotalExp' I want to do a percentage ranking on...

Actually, after running this code, using the Window function divided by the window function requires a lot of processing power and time, so I'm going to decide against that, so...

robertfolkerts (8/3/2010)

---

1.)What are examples of transactions in your system? 2.) I'm imagining that an example of equipment type would be 'automobile' and that 'the blue Honda Accord with VIN...

Ok, finally after two days of continually deleting and installing things I found out how to make it work, it definitely depends on the order in which things are installed....

I am using 2005 variants because that is what everyone else on the project is using, the database is being managed with Managment Studio and SQL Server 2005 on a...

This might be an easier question. Is there some Add-in for SSMS that will allow me to build reports and where can I get it?

EDIT: Is this a hard question...