Hi,

I am using the below one. But really no idea whether it copies your code into their server (kind of leakage).

http://www.dpriver.com/pp/sqlformat.htm

Thanks

Pranesh

Hi,

Below is my Suggestion. Dont drop any Keys (PK,FK). For Example if you drop the keys and dump the data and while recreation if your data having problems...

You need to have Data viewer to find the exact row causing the problem and take it forward by avoiding / correcting the row according to your business. Thanks.

Hi All,

Thanks for all of your valuble suggestions and i will be using 'ChrisM@Work' Suggestion. Thanks for all of your valuable time.

Hi ,

You can check with below code also

Declare @ sql varchar(Max)

Delcare @Tablename Varchar(255)

SET Tablename = 'Test1'

SET @Sql=( 'UPDATE '+ @TableName + '

SET PatientAddress2 =NULL ...

Hi ,

I tried using the below input and it returning

SELECT @Startdate = '1958-06-18' ,@Enddate = '2011-05-24'

Result as 53:-1:6:00:00:00 ...

Hi,

I tried using the below input and i am getting

DECLARE

@Startdate Datetime,

@Enddate datetime

SELECT @Startdate = '2011-05-20' ,@Enddate = '2011-05-24'

SELECT REPLACE(REPLACE(SUBSTRING(CONVERT(CHAR(21),

DATEADD(second, DATEDIFF(second, @Startdate, @Enddate), 0),20) , 3, 17),...

It seems to be getting two days additional the code. Can you please let me know whether i doing correct.

Result i got is

53:10:26:22:11:18

But it seems to be 24 days...

Thanks I will work as such. Thanks for your help

Hi ,

You can try using this function

CREATE function dbo.properCase(@string varchar(8000)) returns varchar(8000) as

begin

set @string = lower(@string)

declare @i int

set @i = ascii('a')

while @i <= ascii('z')

begin

set @string = replace( @string,...

Hi,

Below procedure will provide estimated date to avoid the week ends. Hoildays will change from company to company.

CREATE PROC dbo.Usp_deliverydate @Provideddate DATETIME = NULL,

...

Hi,

This can be achieved using Change data capture in sql server 2008.

http://msdn.microsoft.com/en-us/library/bb500243.aspx

Finding Dates like first day and last day etc

----Today

SELECT GETDATE() 'Today'

----Yesterday

SELECT DATEADD(d,-1,GETDATE()) 'Yesterday'

----First Day of Current Week

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'First Day of Current Week'

----Last Day of Current Week

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Last Day...