SQL Alternative to cursor: area

Am completely lost

Hello all let me first start out by saying I suck at SQL. I can do quite a bit with ASP.NET but SQL Server is on area that has haunted me and I have finally decided to bite the bullet and figure this behamouth out.

Well here is my first problem, which is the biggest reason I can't seem to understand SQL Server or dataases in general.

To have a realtional database you set up tables with foriegn keys and primary keys referenceing the id's like product table has a product name and one of the columns is a user_id displaying the id number of the user in the user table. From what I can tell you are supposed to set up the user_id in the products table a foriegn key to the Primary Key in the user table. I may be totally wrong on this though.

Now my biggest question is how do you retrive this information the proper way to get it ready to be displayed in a gridveiw or a datalist?

I have been reading SQL Server 2005 for developers and reading online tutorials and it seems like they say you need to set up a relationship and because of the realtionship you don't need to do a join, but I never hear how to use the relationship at all.

Please someone help I am so totally lost that i feel like i will never understand. I have spent the last week trying to figure this out and I guess I am just googleing this wrong completely or i am incompentent one of the two.

Thank you.

try this

select a.column1, a.column2 ... b.column1, b.column2

from user a inner join product b on a.userID = b.userID

Hope this help.

Always showing the parameter input area.

Greetings,

Is there a way to force the parameter input area to always show even when default values are specified? I want to always display the parameter area even when I set initial parameters.

Thanks

--|||

The strange thing is in one report I have a date parameter set to a default value of =Today() and in that report the parameter input area is always visible.

For a test I added a kludge parameter to the other report as a date and the input area is still in a collapsed state.

It must be the way the other parameters are processed.

|||

It's odd that your parameters area doesn't display just because the parameters are satisfied. Is this a drillthrough target by any chance? Drillthrough targets will have their parameters areas collapsed, since their parameterization is implied by the drillthrough parent.

The use of an expression for the default value ("=Today()) may short-circuit this, such that the viewer doesn't know ahead of time if the expression for the default value will evaluate. In that case, the viewer may just decide to show the parameters area in case the expression doesn't evaluate to a valid default value.

What build of Report Server are you using? On my test servers, the drillthrough target's parameters area is collapsed, even if I use an expression for the default value.

|||

"Prompt" properties of that parameter is blank?

|||

Thanks for the reply. I have not checked the forum in a while nor have I found a workaround.

This is not a drill through report and the prompt string has been specified.

I am working with 3 parameters and only one is a prompted parameter.

P1 Integer - Internal - No available values -default value of 0 - non-prompt

P2 Integer - Hidden - No available values - default value comes from query - non prompt

P3 - String - Prompt specified - Available values from query (forces drop down list) - Default value from query - prompt

I wish for the 3rd parameter, displayed in the parameter input area, to be visible when the report renders but it's not, the whole area is collapsed.

Could it be something to do of the order or timing of parameter processing?

|||

Made progress!

When I invoke the report via the url command the parameter area is always visible.

When I invoke the report via the navigation functionality of a report item the report is rendered but the parameter area collapsed.

Still dont know why....