In the UK, there's also SQLBits[/url]. Again, not cheap (although there is a free day), but excellent. And they do upload videos of the talks (eventually :-P)

I added it after the last time I had to dig them all out 🙂

Forgive me for my simplistic approach 😀

WITH tmp

AS (SELECT x = 'some text-1'

UNION ALL SELECT x = 'some text-123'

UNION ALL SELECT x...

Nice article, but was wondering if there was any reason you'd do that over using FOR XML PATH to concatenate a string? I'd imagine that the IO of the recursive...

Another guess: -

SELECT sv.SVSEQ, sc.SCACO, ac.f1 AS AccountNo,

ne.NEAN, ne.NEEAN, bg.BGCFN1, bg.BGCFN2,

bg.BGCFN3, bg.BGCUS, sv.SVNA1, sv.SVNA2,

sv.SVNA3, sv.SVNA4, sv.SVNA5, sv.SVPZIP,

sv.SVCSA, sc.SCACO, sx.SXDLM

FROM NEPF ne

INNER JOIN tmpAccountList ac ON NEEAN...

Took dredging it up from the depths of my memory, but I got it. I run a dark theme, e.g. black background. All the rest of the colours are customised...

engstevo (7/3/2013)

---

I have tried this but my head of it department still telling me tht i have failed this is my last chance

Write a SQL statement from the above example...

timscronin (7/1/2013)

---

I have a field with data like below I need to join on

patid

123453

124344ME

323390

3233MS

I need to remove the last 2 charcters if they are not numeric. So my results...

Sure. I'm removing the character from the start of the voucherno...

No problem, just remember for next time 😀

akberali67 (6/29/2013)

---

Just one final question is whether the numbers would be ordered...

kapil_kk (6/29/2013)

---

Srry that was typo misktake in my question n i Have corrected that...

that was trns1 only not trns2...

I tried it but not it is not possible with min max...

First things first, when you visit a technical forum it is always a good idea to provide as much information as possible and to make it as easy as possible...

kapil_kk (6/29/2013)

---

Hi,

I need help in getting this type of output, I tired with MIN and MAX function but didnt get required output:

Create table T1

(Id int identity primary key,

VoucherNo varchar(10),

TransNo varchar(10)

)

Insert...

SQL Server 2012 is good for running totals.

I've also used Hugo's cursor for running totals and Jeff's quirky update method. Jeff's is quicker, so I generally use that for...

ChrisM@Work (6/27/2013)

---

Why read the table twice?

SELECT

sumyy = sum(yy),

xx = ???('summary line') -- where ??? is an aggregate function

FROM tablea

CROSS APPLY (

SELECT SurrogateGroup = CASE

WHEN somedate_column < @startdate_parameter...