Posted on: 10/11/2012 1:30:02 AM | Views : 341

I HAVE A TABLE NAMED COURSE_INTAKE
FIELDS AND SAMPLE DATA IS AS UNDER:-
REGNO,  NAME, ENTRY_COURSE, DTSEN,         DTCOM,           OY,   DEG, OTY,   VDA, RMK
K1234     RAJU    TA-123              21 JAN 2009  21 JAN 2009     OY   
K1234     RAJU    TA-123              21 JAN 2009  21 JAN 2009     OY   
FUNCTION-1
USE [ANIL] GO /****** Object: UserDefinedFunction [dbo].[getBTechBECount] Script Date: 10/09/2012 22:42:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[getBTechBECount] ( @ENTRY_COURSE as varchar(50) ) RETURNS varchar(max) AS BEGIN DECLARE @Count VAR ...

Go to the complete details ...