yes i read it now applied top(100) percent but error shown that ,

Msg 156, Level 15, State 1, Procedure trialbase2, Line 2

Incorrect syntax near the keyword 'distinct'.

as per your guidance i m trying to create a view but it give error

script is

create view trialbase as

select distinct count (a.collegeid)as becount,d.name,a.StreamGroupId,b.DegreeId,b.DegreeName,c.CourseName

from college_degreestreamtransition a inner join college_degreemaster b on...

Is it possible to you to give some guideline or weblink for this????

still i have one query which generate the count but m thinking for trigger so that at project background it will save time of query execution.

is there any possibility to...

Noah i follwed steps to on intelissens but not getting anything

:sick:

is there any other option for it??? mine is sp2

Ok thank you 🙂

Okiesss...

If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is not compatible.

How could...

I am saving data in this manner because please take a look on below example..

streamgroupmaster table 1

streamgroupid NAme

1 ...

actually it is updating for all column with same value... i need to pass condition like where referenceid=@id

e.g :

collegeid ...

i mean to say...

i want to update : 65,87,56 => ,65,87,56,

...

can you please tell me could i reduce the query in store procedure???

because if run run below, then it does not fetch any data,

SELECT ROW_NUMBER() OVER(ORDER BY a.CollegeName) + 1...

yah...it's running 🙂 thanks a lot...:hehe:

Actually i am running this script in store procedure,

ALTER procedure [dbo].[proc_GetCollegeData24]

(

@CourseId numeric(18,0),

@DegreeId numeric(18,0),

@streamid varchar(MAX)=null,

@CityGroupId numeric(18,0)=null,

@mode char

)

As

--...

in that i am not able to understand the first step :-

On the File menu, click New Trace, and connect to an instance of SQL Server.

in my MSSQL there is...

Can you please guide me about creating trace..

please tell me the steps of creating trace...