24
How do I build the ado.net for this.
There are no inputs?
USE [RG_ProjectData]
GO
CREATE PROCEDURE AddProjectQuestionContentFrequency
@ProjectQuestionId int,
@ProjectQuestionContent nvarchar(255),
@ProjectQuestionContentFrequency int,
@ProjectQuestionContentDateTime datetime
AS
SET NOCOUNT ON
SET @ProjectQuestionContentDateTime = getdate()
select ProjectQuestionId, ProjectResponseContent, count (*) ProjectQuestionContentFrequency --------------give alias here
from ProjectResponse
group by ProjectQuestionId, ProjectResponseContent
INSERT INTO [ProjectQuestionContentFrequency] (
ProjectQuestionId,
ProjectQuestionContent,
ProjectQuestionContentFrequency,
ProjectQuestionContentDateTime)
VALUES (
@ProjectQuestionId,
@ProjectQuestionContent,
@ProjectQuestionContentFrequency,
@ProjectQuestionContentDateTime)
GO
