Lowell (7/14/2010)

---

turning the related rows into a comma delimited list is what you are after right?

the easiest way is to use a neat trick using FOR XML.

here's a nice example...

How about this?

--Start by making some test data

DECLARE @TABLE AS TABLE(

[RequestID] INT,

[ApprovalName] VARCHAR(35))

INSERT INTO @TABLE([RequestID],[ApprovalName])

SELECT 15, 'Manager'

UNION ALL SELECT 15, 'Director'

UNION ALL SELECT 16, 'Manager'

UNION ALL SELECT 16, 'Director'

UNION ALL...

Right, I cheated a bit 😛

--Test data

DECLARE @TABLE AS TABLE(

data CHAR(7))

INSERT INTO @TABLE

SELECT '1'

UNION ALL SELECT '1.1'

UNION ALL SELECT '1.1.3'

UNION ALL SELECT '1.2'

UNION ALL SELECT '1.2.1'

UNION ALL SELECT '1.2.2'

UNION ALL...

Chris Morris-439714 (7/13/2010)

---

Sampathsoft, please can you confirm what position 1.1.3 would assume in your sequence?

Many...

Something like this?

DECLARE @thistime AS VARCHAR(10)

DECLARE @shift AS VARCHAR(10)

SET @thistime = CONVERT(VARCHAR(10), Getdate(), 108)

SELECT @thistime,

shift = CASE

...

You killed both solutions 😛

I'm thinking CHARINDEX, split on the period and sort that way?

I think the OP...

Something like this?

--Test data

DECLARE @TABLE AS TABLE(

data CHAR(7))

INSERT INTO @TABLE

SELECT '1'

UNION ALL SELECT '1.1'

UNION ALL SELECT '1.1.3'

UNION ALL SELECT '1.2'

UNION ALL SELECT '1.2.1'

UNION ALL SELECT '1.2.2'

UNION ALL SELECT '1.2.3'

UNION ALL...

I'll be honest, I...

--Sample data creation

DECLARE @TABLE AS TABLE(

[ID] INT IDENTITY,

[Name] VARCHAR(50),

[A/C] MONEY)

INSERT INTO @TABLE ([Name],[A/C])

SELECT 'Cust 1', -£45

UNION ALL SELECT 'Cust 1', £80

UNION...

DECLARE @EXPECTEDDURATION INT

SET @EXPECTEDDURATION = 0

IF @EXPECTEDDURATION = 0

BEGIN

SELECT CONVERT(FLOAT, 1) / CONVERT(FLOAT, 1)

END

ELSE

SELECT CONVERT(FLOAT, 1) / CONVERT(FLOAT,...

You're missing an "END", which you would've been more likely to spot had you formatted your query as below 😉

ALTER PROCEDURE [dbo].[Sp_updateproduct]

-- Add the parameters for the stored procedure here...

http://www.sqlservercentral.com/scripts/T-SQL/69348/

--By Pradyothana Shastry, 2010/02/12

--Step 1: Setting NULLs and quoted identifiers to ON and checking the version of SQL Server

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE...

I don't want to sound rude, so don't take this the wrong way please 🙂

It sounds like you're parsing the query instead of executing.

Try pressing "F5" to execute, or go...

jcrawf02 (7/12/2010)

---

Lynn Pettis (7/7/2010)

---

Alvin Ramard (7/7/2010)

---

CirquedeSQLeil (7/7/2010)

---

Alvin Ramard (7/7/2010)

---

CirquedeSQLeil (7/7/2010)

---

Alvin Ramard (7/7/2010)

---

Jeff Moden (7/7/2010)

---

I'm either getting too old or just lazier in my old age. I no longer fight...

Should work. . .

What happens if you do

PRINT @@ServerName

?

Also, check

SELECT *

FROM MASTER..sysservers