Hello GilaMonster,

How are you doing? Thank you for your responds, the reason I used the FULL Join because I join the CLEAREDDATE of each table to CLEAREDATE of the "ALLCASESCLEARED"...

Hello Ramesh,

Please help me!!!!

For the code that you send me, do I have to type in View/query? Because it says that @Parameter is not declared.

THank you Ramesh,

Create View dbo.ALLCASESCLEARED AS

WITH...

Hello Grass

Why I type exactly the name appears on the Master database but it still gives me "Could not locate entry in sysdatabases for database 'Regional'. No entry found with...

Hi There

you are right, my mistake

But After I fix the DDS of one table then it says "Invalid Object Name 'dbo.BOCLEARED' "

DO YOU KNOW WHY

Hi there,

How can I copy the script of my CREATE TABLE?

THank you

P.S: I'm new to SQL, sorry I try to learn as fast as I can

Hello Grass

Why I type exactly the name appears on the Master database but it still gives me "Could not locate entry in sysdatabases for database 'Regional'. No entry found with...

I don't think your codes work .....here is what I write

Select Sum(b.BOCLEARED) AS BOTotal, Sum(c.CTCLEARED) AS CTTotal, Sum(m.MECLEARED) AS METotal, Sum(n.NHCLEARED) AS NHTotal, Sum(r.RICLEARED) AS RITotal, Sum(w.WOCLEARED) AS WOTotal, Sum(v.VTCLEARED)...

Hello Grass,

So I have to type this code like:

USE GRANDTOTAL; --> what database name should I insert here? IS IT GRANDTOTAL? the database that I wish to transfer data from...

Hello Ramesh,

The code that you give me .....Does it run in view/query? or Store Procedure?

This is what I did below: (but It give a syntax error "Must declare the scalar...

Hello Ramesh,

If I Click ALL

for example, I have 3 offices cleared 5 cases

BO, CT, NH

BO CLEARED 2 cases on 1/1/2009

CT CLEARED 1 cases on 1/1/2009

NH CLEARED 2 cases on 1/5/2009

Then...

Hello Ramesh,

the reason I wish to concatenate them because if there are 2 cases were cleared on the same date. But 2 cases were cleared in different offices, for example

"CT"...

Hello Grass,

How are you doing? Thanks for the respond and help me to understand the codes.

I have a question to ask you about your codes.

Since I don't have the table...

Hello Ramesh,

How are you doing? how was your weekend? Thank you so much for your helps, I have a question and that question is

the store procedure that you sent...

Hello Ramesh,

How are you doing? how was your weekend? Thank you so much for your helps, I have a question and that question is

the store procedure that you sent...

Hello Ramesh,

How are you doing? I have created a store procedure in order to allow me to pull specific report on ASP.NET 2.0 . But somehow when I click on...