ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without ORDER BY, and...

Jeff Moden (7/24/2012)

---

SGT_squeequal (7/24/2012)

---

excuse double post i replied to the other post before seeing the link

you could achieve your reslutls by using patindex

PATINDEX('%[0-9]%',col1)=0

if there is a value between 0 and...

I agree with Jack.

But I can envisage a revolting non-programming option.

Create a derived column which is a massive nested replace - to replace any of 0, 1, 2, ...,...

Are SQL Server tables involved at any point in this process? Or is this a file-to-file job?

I think you meant:

"Stll nutin 2 wk wit 4 ddl n smpl dta"

I have, though not enough to pretend that I am particularly adept with them.

But what I meant is that XML files are so flexible in structure that the XML source...

We've done that. The Datepart solution works in pure SQL Server.

84gopi (7/24/2012)

---

Hi,

My report is cross tab & uses relational modelling now tel me how can I get the required week numbers in my cross tab report based on the season...

Sorry - should have made my answer a bit clearer.

select datepart(week,getdate())

With sample data and DDL someone...

Koen Verbeeck (7/23/2012)

---

Jeff Moden (7/23/2012)

---

Someone just gave me some incentive to study SSIS. It's called XML SOURCE. Yes, I've already (recently, in fact) written some T-SQL to do...

Aha: XMLSQLNinja - just what the doctor ordered! 🙂

That's a cool solution - can you explain how it works?

And if you've got time, perhaps you could also have a go...

Beat me! And I missed the IsNull on ColC, oops.

Have a look here[/url].

You need a nested if...then construction along the lines of

IsNull(ColA)? (IsNull(ColB)? ColC: ColB) : ColA