Hi,

EDD script gives the Distinct Admission numbers from the admissions table from apr2012 to current which are satisfying the conditions given.

TEP gives the total Patients from apr2012 to current...

Thanx Sean,

At present the script will just calculate Numerator/Denomenatorx100 from 2012-apr-01 to current date.

I am looking to split the result for each individual month aganist each ward.

Sample Output should...

grt..thanx for ur help,

now i got clear idea on wat iam doing..

iam using sql 2005,

anyway..i sorted with ur help..thanx.

Thanx for ur help.

i ll try using this script,one mor equesting.....in mytable design i given the RUN_DATE column datatype to datetime.

if i use 103 will it pick only date...

hi thanx for ur reply,

i posted the wrong query..

could you pls refer to my post again ,i changed now, whic i am actually trying to get.

thanx

HI..

thanx for ur reply..

i am posting my script could u pls guide me wher the changes to be made.

USE [EMP_DETAILS]

GO

/****** Object: StoredProcedure [dbo].[SP_FULL_PAS_DAILY_RECORD_COUNT] Script Date: 05/26/2010...

hello sqlwar,

can i run this scrit to get all the indexes details in the DB,could you plese tell is there any change i should do before executing this script,i already...

Thanx chowdary.

hi guys..

its not my college assignment..

wat iam trying to say is this work was assigned to me by my project lead,he asked to get a clear idiea on index and...

its a homework assignment,thanx for the BOL link.

Hello GilaMonster,

actually i was assigned to get more information about Index and and also given a table and asked me to create index to that table.

is it enough if i...

Hi

/*

Using dm_db_index_usage_stats

*/

declare @i table

(

FlagID ...

Lowell, when i open the sql server profiler just iam able to see only the empty page,do i need to open any file here?

sorry for botherring you i am new...

Thanx Lowel,

i selected the database whic i want to perform inthe place master.

i was wondering do i need to create a new folder in the browse for a work...