Have each one be dependant on a previous one completing before starting?

DECLARE @TEST AS DECIMAL(19,11)

SET @TEST = 55.32178699281

SELECT @TEST

,SUBSTRING(CONVERT(VARCHAR(MAX),@TEST),CHARINDEX('.',@TEST),LEN(@TEST))

,CONVERT(DECIMAL(19,11),SUBSTRING(CONVERT(VARCHAR(MAX),@TEST),CHARINDEX('.',@TEST),LEN(@TEST)))*60

/*

55.32178699281.3217869928119.30721956860

*/

Better 😉

CREATE TABLE #sample

(

code VARCHAR(2),

stardate DATE NOT NULL,

...

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...

The reason no-one has posted a response is because you've not made it easy to help you 😉

Read this[/url], post us some sample data and expected results in the format...

First of all, a complaint.

When you get asked to post sample data, I should be able to copy it into my query window and execute to get...

DECLARE @TABLE AS TABLE(

[TIME] INT)

INSERT INTO @TABLE

SELECT 1

UNION ALL SELECT 60

UNION ALL SELECT 3600

UNION ALL SELECT 7200

SELECT totmin / 3600 AS [Total Hours]

FROM (SELECT CONVERT(DECIMAL(19, 5), SUM([TIME])) AS...

SELECT CONVERT(decimal, REPLACE('5,000',',',''))

My best ideas come when I'm sat on the toilet :blush:

Normal solutions simply come to me as I work through a problem.

jeff.mason (8/5/2010)

---

We did look at that. But there are two problems with it -- 1) we'd like to not enable OLE access if we could avoid it (we see...

How's this?

IF EXISTS (SELECT *

FROM sys.objects

WHERE...

Indeed. Or even

SELECT CASE

WHEN NULL IS NULL THEN...

Jeff Moden (8/5/2010)

---

Nulls cannot be compared to anything, not even other Nulls. NULL = NULL returns false. NOT IN is like saying NULL <> NULL and even that...

Try this

It sounds like you posted in the wrong forum then, because this solution works for SQL Server 2008. If you're using a different version of SQL Server, you should've posted...