I also attach Create SQL Of Both table

CREATE TABLE [dbo].[L24Invitations](

[L24InvitationsID] [int] IDENTITY(1,1) NOT NULL,

[senderId] [int] NOT NULL,

[senderEmail] [nvarchar](50) NOT NULL,

[recipientEmail] [nvarchar](50) NOT NULL,

[invitationDate] [smalldatetime] NOT NULL,

[success] [bit] NOT NULL,

[invitationType] [varchar](100)...

Thanks very much

Thanks

Thats good

But is there is way so we can get month name using month number.

Thanks , I got another way so I am posting it here.

I got the solution

sp_help or sp_helptext

the first one will give the signature of the stored proc, the second...

ALTER PROCEDURE [dbo].[Award_Category_Insert]

-- VARIABLE DECALARTION--

@Award_Category_Name as nvarchar(100)

AS

BEGIN

SET NOCOUNT ON

-- AWARD CATEGORY WILL BE INSERT--

Insert into Award_Category_Master(Award_Category_Name, Is_Deleted ) Values (@Award_Category_Name,0)

END

Suppose we have about SP name is Award_Category_Insert and it...

Thanks you both

A good programmer can easily and correctly convert written instruction into code.

Thanks :smooooth:

I do not want to use that table again.

I want to delete it!

Thanks

Thanks fro reply

Why we are not deleting temp table??

Thanks for the reply, nut I think you not get the question.

Here is the example

Post_Detail Table

Post_ID Post_Title

1 Basic Problem

[Post_Reply] Table

[Post_Reply_ID] [Post_ID],[Reply_Title]

11...