Jeff Moden (8/2/2010)

---

Heh... we don't get to keep all that. Most of us...

Pretty sure I haven't understood your requirements, but this should help you to create a solution.

DECLARE @TABLE AS TABLE(

tID INT,

descriptionPoste INT,

domain INT,

subDomain INT,

priority INT

)

INSERT INTO @TABLE

SELECT 12, 2412, 12, -1,...

DECLARE @STRING AS VARCHAR(8000)

SET @STRING = '00000001/01'

SET @STRING = REPLACE(@STRING, '/', '')

PRINT @STRING

??

How reasonable!

--Start by making some test data

DECLARE @TABLE AS TABLE(

PROJECTID INT,

USERID INT)

INSERT INTO @TABLE(PROJECTID,USERID)

SELECT 11111, 1111

UNION ALL SELECT 11111, 1112

UNION ALL SELECT 11111, 1113

UNION ALL SELECT 11112, 1111

UNION ALL SELECT 11112,...

Not really sure what the purpose of something like this is. . . but this should give you what you want.

DECLARE @createdDate DATETIME

DECLARE @months INTEGER

DECLARE @weeks INTEGER

SET @createdDate ='2009-06-20'

SET @months=...

DECLARE @TABLE AS TABLE(

Linedate VARCHAR(40),

Date VARCHAR(40))

INSERT INTO @TABLE

SELECT '4/15/2005', '4/29/2005 12:00:00 PM'

SELECT CONVERT(DATETIME, linedate, 101),

CONVERT(DATETIME, DATE, 101)

FROM @TABLE

You cheated Chris! You changed his sample data 😛

I'm sure that what you posted is what he meant

I'm feeling generous. . .

This is what you were asked to produce

SET DATEFORMAT dmy

GO

DECLARE @TABLE AS TABLE(

datasource_id VARCHAR(2),

EventType_ID VARCHAR(2),

User_ID VARCHAR(1),

period DATETIME,

Notes VARCHAR(255),

Success...

Paul White NZ (7/29/2010)

---

Um,...

For this sort of...

I'm not massively happy with this, but it works for how I understand your requirements.

--Sample Data

DECLARE @TABLE AS TABLE(

[adrs] NVARCHAR(43))

INSERT INTO @TABLE

SELECT ' ?4 one ST ...

WHERE TEN.[term-reason]IN ('EVAS','EVAB','EVRE')

AND TENPER.[ON-TNCY] = 'yes'

)alias

WHERE [Tenant Order]...

Why use a cursor? Why not just do this?

DECLARE @ORDERS AS TABLE(

Seq INT,

Units INT,

Agent CHAR(1))

INSERT INTO @ORDERS

SELECT 1, 200, 'A'

UNION ALL SELECT 2, 200, 'A'

UNION ALL SELECT 3, 200, 'C'

SELECT...

varunfilim (7/29/2010)

---

Hi friends,

I have a scenario where the table values are

ID First Second

162

142

122

261

241

221

From this table I want to generate a combination where Next ID...