I ended up writing a Scalar Function that take the ProductItemID and returns the full name.

CREATE FUNCTION [dbo].[GetProductItemFullName]

(

@ProductItemsID INT

)

RETURNS VARCHAR(255)

AS

BEGIN

DECLARE @Result VARCHAR(255)

DECLARE @ProductUnitType VARCHAR(255)

SELECT @Result = ProductItems.ProductItemName + ' '...

Also i would like to mention i am not a fluent in T-SQL i am doing everything for some projects front and back, and while i can somewhat stumble my...

Your actually right with not needing 2 of the tables, but its not affecting the data. I am still going to pull back only leads where the campaignID matches, so...

Arithmetic overflow error converting int to data type numeric.

It is not happy with this line

SELECT @LeadsinCampaign = COUNT(dbo.Leads.LeadID) AS CountOfLeads

Multi-Part Identifier (dbo.Leads.LeadID) could not be bound

Incorrect syntax near AS

And for final reference because people may Google this one day. I used table variables and they were way easier to think about and work with.

Plus as an added bonus...

That is no problem good luck with rewriting your application. I am slowly gaining traction at this, some days in bounds some weeks are a crawl.

That is just how it...

"Don't over think this" I think i have that problem every day, i guess it would be best to return both data sets in 2 sprocs and handle displaying...

Since returning these to separate sets of data is required for one report i was really trying to keep it all contained in one stored procedure. Since the amount of...

I wasn't clear enough i am sorry. I need it all to go on one row. I guess i could use 3 temp tables, and the results of the 2...

@sean yeah its two different timestamps in the database that will in turn return 2 different results because patients may not necessarily have had orders create in the...

I am sorry let me go back to my specs before i waste anymore of anyone's time.

For future reference for people who come across this down the line the following sproc on the Database side handled everything i need it to handle

In .NET i have a...

See below for a final example of how i accomplish my tasks

Thanks eddie '../@ID' was what wasnt clicking, thanks so much.