hey Andras,

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

Unfortunately on 2005 you cannot pass table variables to stored procedures as parameters. You will be able to do this on SQL Server 2008, but that is not yet...

hi,

now it is working fine.

Cheers!

Sandy.

Thanks Andras,

http://msdn2.microsoft.com/en-us/library/ms189336.aspx

Above URL is really helpful for me,

Cheers!

Sandy.

Hey Kenneth,

Now I am following this way.

I have added one more column as RegionType.

If it is Region then it is 0

---

If it is City 1 then it is 1

and...

hey Andras,

I have a quick question for you,

If you are using more than one Stored procedure, then how can you handle the transaction process,

Ex: -

SP -1

(

Begin Tran

...

Yes Andras,

Function would be better here.

Cheers!

Sandy.

Hi Kenneth,

Ans: Yes, this is the Data coming from Webservice.

Ans: Nope,...

Hi,

Thanks a lot.

Cheers!

Sandy.

yes,:)

I got it,

Can you please tell me what is the use of Timestamp Datatype then???

Thanks..

Sandy.

Hi GilaMonster,

In my Web Application the code is written in such a way that this format of date will support for all type of database not only SQL Server.

otherwise I...

Hi all,

I am following the same way what you are suggesting now.

Ex : select convert(varchar(30),getdate(),121)

But the important for me is storing rather than fetching the data.

Any other ways??

Cheers!

Sandy.

Thanks,

But I need to store the date data in this format as like Oracle and MySQL

because the application is only changing the connection to the SQL,MySQL & Oracle...

Hey Grant,

I convert the MySql Script to SQL Server Script very easily,

But right now also working on that same XML Path,

If I will find any way, I will get back...

Hey Grant,

I got your point,

Let me check with development team and I will get back to you, on this.

Grant, Do you have any idea how to convert a MySQL script...

Hi Brad,

Thank You,

I will proceed my work as per you and Grant Specified initially.

If any needs, I will get back to this topic.

Cheers!

Sandy.