Hello Slange,

Forget about the question that I just ask you, I solved it.

Thanks

Joseph

Hello Slange,

I ran the codes that you suggested me to change it, and it works. But there is a small problem that I want to ask you, and that question...

Hello Slange,

I am confused, would you please tell me what insert I should put back? and What changes should I change at the end?

Thank you

Hello Slange,

Here is the new code:

It gives me an error: "Invalid column name 'ClearedDate'"

ALTER PROCEDURE [dbo].[WklyCasesClearedWithNoReturns]

-- Add the parameters for the stored procedure here

@Start Datetime,

@End Datetime,

@office varchar(5)

AS

BEGIN

--...

hello Slange,

I take your suggestion and added the codes in my codes. But It gave me an error : Invalid column name 'Type'

Do you know why?

Thanks

ALTER PROCEDURE [dbo].[WklyCasesClearedWithNoReturns]

-- Add...

Hello Vijaya Kadiyala

How are you doing? It's ok, I am apoloziged for not being smart like you as an expert in SQL. I've tried really hard to learn and wrote...

Hello Gila,

Thank you very much for your suggestion, I will take your advice. I have a problem in SQL, and please expert helps me out and give me an advice...

Hello Gila,

How are you bro? I am not talking about you, because you tried many different ways to help me. So, there are no words than saying "Thank you so...

Hello Florian Reischl,

How are you doing? Thank you so much for your helps, I wish there are more people like you to help new developer at their beginning stage of...

Hello Schnurdle

How are you doing? Thank you so much for your efforts to help me out and I already solved this issue. Again, thank you so so much

Very...

Hello Paul,

Thank you for your helps, I already got the answer for it. Anyway, Thank you so much.

Very Respectful

Joseph

Hello Vijaya Kadiyala

How are you doing? I try to be nice to ask for helps and you think you know the answer for it. This is not an issue...

Hello Gila,

Thanks for the comments, I do know how to write simple query like you told me so. But I don't know how to post the table with sample data...

Hello Gila,

Thank you very much, you are the man and thank you for teaching me how to solve SQL issues.

I have a question which relates to SQL

First, how can...

Oh no

How can I locate the default of specific column in the table?

I know how to delete

Thank you

🙂