Hi,

use this query. It will help you to find out the desired result :

Select usertype,count(*) userCount ,

(count(*) * 100 / (select count(*) from table_a)&nbsp [percent]

from table_a

group...

Hi,

First of all check how many rows in your table :-

1) USE THE BELOW MENTIONED QUERY FOR IT :

Select count(*)  from table

if you got the output then analyse how...

Hi,

Use the below mentioned query to solve your peoblem..

SELECT qid,ques_text,

(select sum(ques_ans) from QUESTIONHISTORY

where q.qid=asst_qid

)Ques_Answered,

(select sum(ques_corr) from QUESTIONHISTORY

where q.qid=asst_qid

)Ques_Corrected,

(select isnull(convert(int,sum(ques_corr) * 100 /CONVERT(NUMERIC(18,2),sum(ques_ans))),0) from QUESTIONHISTORY

where q.qid=asst_qid

having sum(ques_ans) <> 0

)Percentage_Ques

FROM QUESTIONS q

Hopping...

Hi Ozell ,

You have to install the Sql Connectivity Tools on the Sever in which Visual Studio 2005 is installed.

Then you will be able to access it.

I am not very...

Hi Mark,

Open the Enterprise Manager then Select the database -> Right Click on it -> Go to the Database properties -> Open the Data file Tab -> Change the alloted...

Hi,

This type of problem exists when you are using the linked queries that reference the remote server which could not be login on a trusted connection coz, Sql uses the...

Hi Omari,

can you send the *.mdf & *.ldf file of your database to me.

at mailgupta_amit@yahoo.com . I can sougth out your problem...

Hey,

I forgot to provide my mail address :

Amit.82.gupta@gmail.com or

mailgupta_amit@yahoo.com

Thanks,

Amit Gupta

.MCDBA.

** Task is not easy but solution is easy.

Hi,

You have an Sql *.mdf file. Can you send it to me i can solve your problem coz it ia s big process i can't explain to you bot i...

Hi,

Try this query to solve your problem .

/* Table Creation */

create table data

(

val_data varchar(10)

)

/* Inserting Data into Table */

insert into data

select 'ABC-0'

union all

select 'ABC-1'

union all

select 'XYZ-0'

union all

select 'XYZ-1'

union all

select 'XYZ-2'

union...

Hi,

Try This One !!!

select * from (

select job_id , count(*) activity_type_id from activities

group by job_id)a

where activity_type_id=1

Thanks

Amit Gupta

IN -- > is running faster bcoz the table is not sccaned here it provides direct values to its execution plan.

For more fast performance use the Exists :

Your modified Query :

select ...

Can it will help you,

select *,left(Convert(varchar,getdate()),8) Create_date

from <your table>

Regards,

Amit Gupta..