Hi thanks for your answer. I was just going through books online and found out that in these situations, we can also use parameter queries.

Can I define this parameter...

hi thanks for answering

But what are parameter queries for in SQL?

Thanks for that David

It works fine now

cheers

Hi

thanks for your help..

I copied my database into the location which u told .But still SQL is giving problems.. It says  "please select a data source"

What do I do...

The Import/Export wizard of SQL server 2005

Hi guys

The problem is i have installed sql on my c:.Its not on the network because if i try to put it on the network, it gives errors and does...

Hi sorry that was a typo!

I tried  this

UPDATE providerlistforfirstq

SET

Practitioner_Enddate = '2099-01-01'

where...

sql server 2005

Hi Sergiy

This is the format which sql recognises.. Its not any kind of virus.. its the data which we recieve from our clients on weekly basis..

Here is the data from the text file...

Date dispensed Outliers Formulation ID Provider Number (dispensing) NSS flag Patient category Units dispensed Total days supply

1/01/2006 12:00:00 a.m. normal 106509.00 7952 I A 120.00 30.00

1/01/2006 12:00:00 a.m. normal 106509.00 8208 I A 360.00 90.00

1/01/2006 12:00:00 a.m. normal 106509.00 9460 I A 120.00 30.00

1/01/2006 12:00:00 a.m. normal 106509.00 10184 I A 120.00 60.00

1/01/2006 12:00:00 a.m. normal 106509.00 10291 I A 120.00 60.00

1/01/2006 12:00:00 a.m. normal 106509.00 11149 I A 120.00 30.00

1/01/2006 12:00:00...

"Select  Practitioner,  sum(Case when Upper(Locum) ='YES' Then 1 Else 0 End) as YCount,

     sum(Case when Upper(Locum) ='NO' Then 1 Else 0 End) as NCount

  from Practice_Test

  group by Practitioner"

when i try this bit,...

hi Sreejith

thanks for the help

i tried this query but there is some syntax error which says- incorrect synax near group.

"PractitionerGroup ON Practice_Test.Practitioner = PractitionerGroup.Practitioner"

I could not understand this above statement....

Cheers buddy

It works!!!

Thanks for help

ya because my column just has month numbers .there is no date in it.

I just tried the query which u suggeste. It gave me the names of all the months.

So...

Good stuff.

Thanks for that!!It works..

U are a legend

Cheers buddy