So you saying that if I remove the defaults, the report will show the parameters that the user will be allowed to select?

Is there anything specific that needs to be setup in reporting services?

what are scalar user-defined functions used in queries?

I tried to use dbo.DelimitedSplit8K and my t-sql 2012 does not recognize this item. I pointed to the msdb, tempdb, and master tables and that did not solve the problem....

found answer

There is no error. The rows are not inserted.

How would you change the merge statement?

How would you change the merge statement?

Would you give me an example of the insert statement using the output statement obtain the values from the output statement to obtain the values from the inserted statement? How...

I plan on updating one record at a time. Could you show me the sql to do the following.

"stuff the value of SCOPE_IDENTITY() into it and then use that...

Here is a definition of the input table, CREATE TABLE [dbo].[InputTable](

[schoolNumber] [varchar](3) NULL,

[lockerNew] [bit] NULL,

[lockerType] [varchar](3) NULL,

[lockerLocation] [varchar](30) NULL,

[lockerGrade] [varchar](4) NULL,

[lockerReserved] [bit] NULL,

[lockerShare] [bit] NULL,

[lockerNumber] [varchar](10) NULL,

[lockerSerialNumber] [varchar](20) NULL,

[lockSerialNumber] [varchar](20)...

found answer used cdec

Here is more of the sql that is listed below. Can you tell me what the logic is:

WHEN (SELECT SUM(a.CasesDelivered) FROM (

SELECT TOP 1 bola.CasesDelivered FROM [NC].[Lad] bola

WHERE bola.Active =...

This is a Microsoft known problem.

Can you tell me how to accomplish the following tasks:

"Check if you have set report cache in process option, or run report from snapshot."

Can I do the following in...