Create Table #WeeklyActualClearedCasewithNoReturns

(

SSN INT, DDS Varchar(3), DECLEAREDDATE Datetime, SOMATICMCCLEAREDDATE Datetime,PSYCMCCLEAREDDATE DATETIME, DESECONDCLEAREDDATE DATETIME,SOMATICMCSECONDCLEAREDDATE DATETIME, PSYCMCSECONDCLEAREDDATE DATETIME

)

INSERT INTO #WeeklyActualClearedCasewithNoReturns

Select '000112222', 'CT', '1/1/2009', ' ', ' ', ' ', ' ', '...

Hello there,

Before I type the codes in there, do i have to click on any IFCode shortcuts?

Thank you

Hello there,

How can I remove the default? would you please tell me specific steps that I should do?

Sorry I am new to this

Thank you so much

Hello there,

Would you please tell me why I could not create a table with sample data in the table?

Thank you

Joseph

Hello Florian Reischl

Thank you so much for your efforts to show me how to post my question, so I can get better help.

I am new to SQL, so please...

Hello there,

Thank you so much for showing me how to post SQL code, would you please tell me how to create a table with the sample data in table?

Thank...

Hello NOELD

How are you doing? First, thank you so much for your codes, I am greatly appreciated your helps and this is a homework that I try to do. So...

Hi Steve,

I try to put some sample data as it requires in this forum and their format. But I could not, would you please take a look at the way...

Hello There,

How are you doing? Thanks for the respond and would you please show me how to post the sample data on the forum with the example of how to...

Hello There

I did not mean to make someone madding at me, I just try to seek all advices from all experts. Again, I am sorry.

I am using SQL 2005

Thank you...

Hello there,

I am sorry that I forget to post the codes. I'm using for my own project.

ALTER PROCEDURE [dbo].[FYTDClearances]

-- Add the parameters for the stored procedure here

@Start Datetime,

@End Datetime,

@Parameter...

Hello,

I am using SQL 2005

Below are the codes that I wrote

ALTER PROCEDURE [dbo].[FYTDClearances]

-- Add the parameters for the stored procedure here

@Start Datetime,

@End Datetime,

@Parameter varchar(3) = 'ALL'

AS

BEGIN

-- SET NOCOUNT ON...

Sorry Lynn,

I try to get much helps as possible.

Hello There,

I mean if there is a case which has assigned to DECLEAREDDATE, OR SOMATICMCCLEAREDDATE, OR PYSCMCCLEAREDDATE then there will be a date in one of those fields. and count...

I am sorry to forget posting my store procedure.

ALTER PROCEDURE [dbo].[FYTDClearances]

-- Add the parameters for the stored procedure here

@Start Datetime,

@End Datetime,

@Parameter varchar(3) = 'ALL'

AS

BEGIN

-- SET NOCOUNT ON added to...