Hi,

In my table, I have a date column but it is of type Varchar (Max). I know it and I want to keep the datatype for the table like this....

Hi,

Need help with converting from character string to datetime.

I used the following code:

WHERE ((convert(datetime,TEI.Cert_Date,101) > convert(datetime,MAL.Cert_Date,101)) OR MAL.Cert_Date IS NULL)

The above code fails to do conversion...

Hi,

Just tested your code. It works fine now. But I dont understand, because the only difference is in the way you declared the table. Now you creating a table with...

Hi,

I have also run your code, with the Output Clause. I get the following error

Msg 4104, Level 16, State 1, Procedure stored_proc2, Line 50

The multi-part identifier "Temp_Event_Import.Cert_Status" could not be...

Hey,

Thanks for the code. But I knew Join gives you the query...The reason I used my codes is because I want to set something in one table to a value...

Hi,

I am using the Output clause, the thing is I can't put a Output clause here. I just want to see which rows have been updated. Tried before the Where...

Hey,

If I want to use the OUTPUT clause, does this mean I will have to create a separate table, where all the updated/inserted/deleted rows will be entered? If so then,...

Not familiar

The sub-query is the bit between the braces, the sub-query in itself is fine and valid, its because we are using an operator that expects comparison against a constant rather...

Hey,

Also can you tell me if there is a way to check how many rows and which one have been either updated or newly entered to the MAL,...

Hey yeah I get a number of rows from the query.

INSERT INTO [Tasnim].[dbo].[Master_Application_List]

([AppName]

,[AppVer]

...

USE [Tasnim]

GO

/****** Object: Table [dbo].[Master_Application_List] Script Date: 07/22/2010 16:35:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Master_Application_List](

[AppName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AppVer] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AIT_ID]...

Hi Paul,

The tables were created manually. Only AppID column was created using code as it was declared as int primary key identity in Master_Application_List table. App_ID declared as foreign key...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[stored_proc2]

-- Add the parameters for the stored procedure here

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET...