based on the limited data, one way is substring. a combination of left and right could work as well.

DECLARE @STR VARCHAR(20)

SET @STR = 'W~W51247~0~1~0'

SELECT ...

you can get counts with this:

SELECT QUOTENAME(SCHEMA_NAME(t.schema_id), ']') + '.' + QUOTENAME(t.name, ']') AS fulltable_name

, SCHEMA_NAME(t.schema_id) AS schema_name

...

SELECT ref

, seq

, COUNT(seq)

FROM demo AS D

GROUP BY ref

...

Good stuff here - I like the other options!

I bet there are better options, but here is one.

Create table #Test

(SNO int identity(1,1), Code varchar(6), Amount Money, Type Varchar(10), Month int, year int)

insert into #Test values ( 'D10001', 10,...

http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en

I had the same issue, I am downloading and installing now.

Jeff Moden (5/14/2010)

3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely disagree with (either in...

The two things I would like to see are:

1) Lock old (after defining "old") threads from being resurrected, or, a "warning" to the new poster that this thread is...

Something like this?

DECLARE @entereddate DATETIME

SET @entereddate = GETDATE()

SELECT DATEADD(MONTH, -6, @entereddate) AS past,

@entereddate,

DATEADD(MONTH,...

Being that you have a table with columns to keep, you can try this:

CREATE TABLE #Keep ( NAME sysname ) -- Create the columns to KEEP

INSERT INTO #Keep (...

Just a guess, what about something like one of these?

select suser_sname(), suser_name()

a quick google search on XIRR turned up this:

http://forums.databasejournal.com/showthread.php?t=46094

DOH! :w00t: Good call. 11 second run time now.

Lowell (5/11/2010)

---

you must have a monster "old" desktop; I've got a decent 2.8Gig developer machine and it took 5 times that long; 01:29 to run your code,01:28 on second run.

25...

Jeff Moden (5/10/2010)

---

STUFF works fine but let's demonstrate a little trick that a lot of people don't know about with SUBSTRING... you don't actually have to calculate a length for...