New Commer (8/10/2010)

---

Wow !! Really very Happy !! Thanks a Lot ColdCoffee !! U Rocking txtPost_CommentEmoticon(':-)');

It works .. hooooo...

Wondering tht the task become possible from impossible (As i started this...

Try this , mate..

-- Conditionally drop if the procedure already exists

IF OBJECT_ID('dbo.Testing') IS NOT NULL

AND OBJECTPROPERTY(OBJECT_ID('dbo.Testing'), 'IsProcedure') = 1

BEGIN

...

For the ease of coding, i included an extra IDENTITY column so as to identify each record.. now, the code that will update enddate column with a value of (...

Are u using RightClick -> Export or BCP or SSIS for exporting?

Aspg (8/10/2010)

---

Hi ,

Here is the sample data .

Enddate is currently null .

What i want is the endate of 1st row should be the yesterday (from startdate ) of 2nd row...

Try this:

-- Conditionally drop if the procedure already exists

IF OBJECT_ID('dbo.Testing') IS NOT NULL

AND OBJECTPROPERTY(OBJECT_ID('dbo.Testing'), 'IsProcedure') = 1

BEGIN

PRINT 'Dropping Stored procedure Testing...'

DROP PROCEDURE dbo.Testing

END ;

GO

-- Procedure Definition

CREATE PROCEDURE dbo.Testing

@Date...

Need Sample data, sample script files (create table, insert into table etc etc) and a CLEAR desired-output.. This is help us to work on this straight away, friend !

Awesome 🙂 ... which solution u used, mate ?

And if your input is a string (varchar/char/nvarchar) , you can do this :

declare @i varchar(10)

set @i = '1234567890'

select stuff(@i, (len(@i) - 1), 0 , '.' )

Hope this helps!!

Would this help you ?

declare @i int

set @i = 1234567890

select cast( (@i / 100.00) as numeric(10,2))

To be precise

CAST (date AS VARCHAR)

-- OR

CONVERT (date , VARCHAR)

SET NOCOUNT OFF .

When u normally execute a query, you sure will get the number of rows affected in the "Message" Pane of the Results Window, unless u specify SET...

No, you can not, unless you are using Dynamic SQL..

If u want to use variables to decide the column u want to aggregate your result set , i can give...

Mr.Corn, are u populating data into a Global Temp table ? If yes, then are there any jobs scheduled at the same time that will drop the global Temp Table...

Try this:

--update table

--set ecode = NULL

select * from table

where

patindex('%[^0-9]%', ecode) > 0

or

...