I would need any Simple Query for generating 4-4-5 calendar that most of the companies use in USA .. My Company was not using it before and i was...

So any chance of building the Dynamic Where Clause Query for the above statements assuming that some parameters could be NULL ..Thanks In Advance

HI in the above 9 parameters it can have only one based on case statement or it could be NULL for example

In @Where parameter i was giving ...

I will not be expecting any other parameters ..Only i do have only 6 parameters in where Clause

Thank you very much ... that worked for me 🙂

Thanks every one for the suggestions and from all above suggestions can we only insert newly added rows with out the updated rows ?. I do have one identity column...

Thank you every one my issue was resolved as you all said after removing the comma delimiter in my input Date string parameter ..

I have One Data Set which brings up Multiple Dates from a Table and User can Select Multiple dates from that drop down list ...

No it doen't handle multiple Dates ... I need help in changing the Stored procedure to handle multiple Dates ... Thanks in Advance ..

So Is it applicable for passing the Multiple Dates in to the Parameter .. I was using the @StartDate in StoredProcedure Which is a DateTime DataType and from SSRS...

i was using the below query in oracle and was storing it in variable and i tried to save it a int32 but it was not allowing me to do...

hi you can handle errors in SSIS by going to event handler tab and from there you can capture error code, error description for any event you select .

Now My issue was resolved once i changed the protection level of the package to encrypt with password and i gave the credentials at Set values in SQL Agent job...

I have the Package deployed by following steps

-->Right Click on Project and Deployment utility is set to true

-->Build the Solution

-->Go to bin\Deployment and run the deployment tool and selected file...

I am using SQL Server 2008 R2