Elliot,

I just finished a year long automation project and I had to put everything in temp tables and variables because I don't have write access to the database.

Well, anyway thanks...

Elliott W (10/6/2009)

---

You are part of a publically traded company right?

You can often get seperation of duties by being the requestor of the change and the verifier, but not the...

Thanks bitbucket,

I do have some knowledge because I used to work with QA but that's when I was in IT.

I don't have access to financial information

Thanks

-Michelle ...

Aw, cool! Thanks guys... this is part of a much bigger more complicated problem I'm working on, so I might be back, but I hope not! 😉

-Michelle

If you give a sample of the result set that would help too!

When doing your sum function make sure to check that you have the proper datatype... or else...

dreamslogic,

You'll want to use the 'count' function to find the total number.

select count(col.name)

-Michelle 🙂

Hi ramses2nd,

GSquared is right you'll want to use a CTE for this one... (I know this because he taught me this once before and I've used it many times...

Oh Cool!! That worked Matt! You know I never thought about doing it that way!?

I learn something new and cool everytime I come here... thanks to all...

If I want to get pizza then I would want a large pizza that had pepperoni or jalapenos

select * from pizzas inner join toppings on toppings.pizzaid = pizzas.id and (toppings.name...

I tried your suggestion Drew and it's what I'm looking for!

Except... I'm getting a 'Incorrect syntax near 'END'.' I'm sure it's something dumb I'm overlooking.

-Michelle ...

Many apologies, thank you very much for your assistance.....

This my code:

SELECT DISTINCT CRM_Orders.TRANSACTION_ID, CRM_StatusCodes.USER_STATUS, CRM_OrganizationalUnits.STEXT

FROM CRM_Orders INNER JOIN

...

Hhmmm... still kinda' stuck here.

I broke it down and I have two queries:

SELECT DISTINCT

count(CRM_Orders.TRANSACTION_ID)

FROM CRM_Orders INNER JOIN

...

Here's the BOL for reporting services:

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

You can pass all your parameters directly in RS, or use their expressions to handle the critera outside of your code. I...

I'm sure there's a BOL somewhere, I just haven't taken the time to look.

In Visual Studio, you'll want to have the BI component installed to create the report format. ...

Sure no problem, Benyos.

Here is my query:

SELECT DISTINCT CRM_Orders.TRANSACTION_ID, CRM_StatusCodes.USER_STATUS, CRM_OrganizationalUnits.STEXT

FROM CRM_Orders INNER JOIN

...