Hi Jack,

I got it to work but in a different way. I created a stored procedure and aliased both fields with the same name. So in the parameters...

Hi Jack,

That is exactly what I am looking for!! Unfortunatly I am not exactly sure where to put the code(=IIF(Parameters!SearchWhat.Value = "Contract Number",

"Select ContractNumber as value From ContractNumber",

"Select...

I'm using the jump to url:

=Fields!LinkPDF.Value

The value is a Share on a server eg \\EXPL0009\Reports\PDFs\...

I'm sorry but don't completly understand. I'm calling the SetReportParameters() method on load which generates the report. I'm not using a URL to run the report because it...

I use Where 1=1 in some of my SP that dynamically search the DB as follows. When the search form opens it will display all items initially because no...

The If...Else statement fixed that issue. I'm getting the same results from the vb form as I am from running the SP in the SQL studio.

Hi I was working as a Network Admin and got promoted to a DBA role(newly created position) as few months ago. I found Brad McGhee's DBA Best Practices guide...

Thanks for all the replies.:)

While doing some testing with the Profiler I noticed that when I executed the SP in the SQL studio it returned this:

EXEC@return_value = [dbo].[DynamicSQLSearch]

@PetroNo = N'c93'

Only...

Here it is.

Private Sub FillToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillToolStripButton.Click

Try

...

Thanks for the advice. I got a book called (SQL server 2005 T-SQL recipes) great book with good examples, just doesn't have what I am looking for in this...

I'm a total newbie. I just found out what SSIS was yesterday and my SQL writting ability's would be at a novice level. Here is my situation, I...

Are you suggesting that I import the spread sheet into a flat table then use an insert trigger to redistribute the data appropriatly within the trigger. Is so can...