Thanks to every one for the quick help. This works fine for a table. One more help I need.

I have a partitioned view in which I have all these tables...

Thanks a lot brother. Let me experiment with this. This was great help 🙂

That's great help ... Let me play with it and get back... Thanks a lot buddy... 🙂

Thank you all 🙂

Another question is ,

This table will be loaded with data from a feed. At the time of loading , the same table is also used by...

I am not very sure. But they said it is to improve the performance and efficient file storage management

Yeah!! This was what I was looking for .. Thanks dear 🙂

Hi,

Sorry . I am sharing the scripts below

--------------------------------------------------------------------------------------------------------

/****** Object: Table [dbo].[tmpCustomers] Script Date: 03/30/2011 02:11:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tmpCustomers](

[CustomerNo] [varchar](50) ...

Thanks dear. But still does the same. Showing that default date in table

Please see the script

CREATE TABLE TABMobile

(

SaleDate datetime,

NoOfPiecesSold int

)

GO

INSERT INTO TABMobile SELECT GETDATE(),12

INSERT INTO TABMobile SELECT GETDATE()-1,20

INSERT INTO TABMobile SELECT...

ok. will do . thanks for ur reply

Hi ,

Thanks for the reply. I am attaching the zip file.

Regards,

Sanuj.S.S

Hi ...

Thanks... 🙂

The first line worked. But when I try the OPENROWSET command, it is giving an error

Msg 4832, Level 16, State 1, Line 1

Bulk load: An unexpected end of...

Thanks...

But how can one column handled using OPENROWSET ? Could you please give the command ?

Hi Friend,

I have a situation where udpation happens in different tables according to the input parameter value. I thought of finding some shortcut to do it in one shot.

Anyway, Thanks...

Hi Pals,

Thanks for the reply... I did it using dynamic SQL . but tiresome work 🙁

Best Regards,

Sanuj