DROP TABLE #temp

DECLARE @university_id varchar(8),

@college_id varchar(8),

@department_id varchar(4),

@status varchar(20),

@high_mark int,

@low_mark int,

@exam_date datetime,

@sqlselect1 varchar(1000),

@Sqlselect2 varchar(1000),

@id1 int,

@id2 int

SELECT IDENTITY (int,1,1) AS id1,a.university_id,a.college_id,a.department_id,a.exam_date, 'Status'=

CASE WHEN electric_power >b.grade_level2 then 'pass'

WHEN electric_power <b.grade_level1 then...

yes ,I need to select the result(max(id)) into a variable. Also I have one more dynamic sql which returns onother value. So I am selecting these two results into...

yes, Its returning nothing.

I am sorry for being not so clear with my requirement.

Let me explain you in short and brief.

I am grouping some of the colleges and assing them to group2 as...

what should be the data source when we import data from db2 using dts.

thanks.

For each company we have 4 departments.

Suppose for company 1 we have 2 departments and 2 and 3 and they have dept_no_count is 23 and 34 respectively.

But in my report...

DECLARE @name varchar(500)

DECLARE @len int,@start int,@start1 int,@len_original int

SET @start1=0

SET @name='aaa,bbb,ccc,ddd,eee,fff'

SELECT @len_original=LEN(@name)

SELECT @len=LEN(@name)

SET @start=1

WHILE @len>1

BEGIN

SELECT SUBSTRING(@name, 1, CHARINDEX(',', @name)-1 ) as user_name

SELECT @start=CHARINDEX(',', @name)+1

SELECT @start1=@start1+@start

SELECT @name=SUBSTRING(@name,@start,(@len-@start))

SELECT @len=@len-@start+1

IF @start1=@len_original

BEGIN

SELECT @name AS...

Can anyone help me in this issue?

Thanks.

Unfortunately the table cannot be normalised. all the columns should be in one table.So if the rowsize is greater than 8k is it going to affect the performance of my...

I tried that also,But I have a connection which is an application user for that DB. So How can disconnect forcibly that user from th DB.I guess if i can...

I'm sorry to say that now the DB is in emergency mode so i can't drop it.

How can i drop when its in emergency mode.

Thanks.

Yep, I could not do it either.

Yes,But it didn't work for me,So I have set the database to emergency mode.But how can i drop this database.I have created another DB with all the Data base objects...

update sysdatabases set status = 32768 where name = 'pubs'

 

When i run the above command I got the following server message.

 

Ad hoc updates to system catalogs are not enabled. The...

 WHen i ran EXEC sp_resetstatus 'dbname' i got the below message.

Prior to updating sysdatabases entry for database 'ihatespamdb', mode = 0 and status = 4194333 (status suspect_bit = 0).

No row...