I find the article conceptually and technically difficult to understand as I've only been working with SQL for about two weeks. I will certainly attempt to give it a read...

I believe it should conceptually look something like:

select @sql = @sql + 'and ' + @system_Status + ' LIKE ''%,'' + system_Status + '',%'''

but I'm generating...

I'm actually noticing now, that your originally revised query string does not allow for multiple parameters in @system_Status. I can enter as many arguments as I want, and it'll execute,...

Sean, that worked perfect...

I understood the Replace function was doing nothing, I had written it at a time when I was in fact replacing something....

Just to get a better understanding...

So I'm able to create three separate query's to pull BUY SELL and CONTRIBUTION from the string, but now that I've written these queries, how is it that they prove...

I'm not sure -- just started using SQL about a week ago. I will research and see if that will work.

Chrissy,

Thanks so much for all your help. Using the IF statements worked. I built it down to be a little more concise just using Boolean logic

Begin

declare @idnum varchar

select @idnum...

The parameter is to limit the data.

If 'BUY' is entered for the parameter, only buys would be returned

If 'SELL' is entered, only sells would be returned

however, if you enter...

Chrissy,

I took a look at the guidelines, and I can't seem to figure out exactly how to post the data the way they've shown. I've done my best to...

That query was not functioning properly.

The below query is actually pulling back the proper data. However, when I use 'ALL' as my variable, it is running the query twice (the...

Hi Sean,

The query itself works fine, I'm having an issue converting this into a temp table. I'm not even quite sure how temp tables work in theory, but I'm attempting...

Can anyone point me to good literature on learning how to do 'Temp Tables' and the like.

Basically I need to create this same exact table with the same exact...

Eh, That was a really easy fix. Sorry for the trivial question. Thanks guys!

Thanks for all the help so far.

Initially I thought once I had the query set up, it'd be easy to put a WHERE clause in (for this purpose I'm...

Edited: Thinking about it, you probably don't need that third table. Try this: -

SELECT A.Portfolio, B.PortfolioID, SUM(B.MarketValue) AS SumOfMV,

COUNT(B.SecID) AS [# of Securities]

From ERTutAccounts A

INNER JOIN ERTutPositions B...