Thanks both of you for helping. What I was not understanding was the part where the first charindex is subtracted from the second.

I'll definitely be saving this example to...

I've worked on this for hours and am completely stumped.

Thought that this would work:

declare @text varchar(250)

set @text = 'Login succeeded for user ''domain\user''. Connection made using Windows authentication. [CLIENT: xxx.xxx.xxx.xxx]'

select...

Thanks for responding. I'm trying to impliment this but have not successed yet.

What I think...

Thanks for responding Celko.

I was trying to avoid typing out and possibly misspelling SQL Server, Oracle, MySQL over and over again by using the foreign key approach. In this case,...

When I have a cascading parameter, I understand that when the first is selected, the query must run to generate the list for the second parameter. Does it have...

Thank you. I'll take a look.

Howard

This worked. Thanks a lot. There are now two drop down lists to set the parameters in SSRS but it seems to be working. Now I have to find...

Thanks, I'm eager to try it. That scenario would be perfect.

Thanks for responding. Your example is very good.

I should explain a little better. This query will go into SSRS so I think I am limited to a single variable which...

Marcy, I think it is close to working.

Using your example, I tried to do it this way:

declare @Version int

set @Version = '10000'

SELECT DP.Name, DV.Version

FROM DatabaseProduct DP

JOIN DatabaseVersion DV

ON DP.DatabaseProductID...

Thanks Marcy, I'll give this a try.

You are right, the datatypes are int so 'ALLSQLSERVER' will not work. I was doing the query in my head and didn't think...

This is working now but I would like to make the unassigned slice white/transparent. The color pallet is bright pastel.

I thought of something like this as an expression but can't...

Michael,

This worked perfectly. The technique that you used to create the join is something that I will no doubt need very regularly.

It really does make sense now...

I got this working by creating a union query that adds a row that is 100 - sum(utilization). Not sure if there is a better way.

Thanks for your suggestion Doug.

Thank you Doug. That is what I would like to do. I may need help setting it up.

Howard