Definitely not the most straight forward approach to this. does something like this work for you?

SELECT max(tblPODetail.PONum), tblPODetail.PartNum, tblPODetail.UnitCost

FROM [SharePointProgress].[dbo].tblPODetail

group by tblPODetail.PartNum, tblPODetail.UnitCost

sqlzealot-81 (10/10/2011)

---

I guess, you can achieve by the below way,

SELECT

CASE IsNull(COL1,'') WHEN '' THEN 'Is Null'

WHEN '0' THEN 'Is Zero'

WHEN '1' THEN 'Is One'

WHEN...

Let us know if figure out how to do this. Other people will find this via google or such in the future and would be nice to let them know...

VERY true there!!!

Of course there is nothing automatic about Visio. It isn't like you can put in a query and it will generate a nice UI. It can be very challenging sometimes...

This should be totally doable in tsql. A combination of Jeff Moden's splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D and maybe a for xml should just about get it there.

I don't have much time to...

barblm (10/7/2011)

---

I do not have a great depth of knowledge of SQL, but couldn't you simplify this by adding the total minutes planned to work for a day and compare...

I have found that visio is a decent tool for this. You just have to break down the query to logical steps instead of all at once like sql does....

robert.daniel (10/6/2011)

---

I'm going to use a temp table and convert the text field to a varchar(max) field, update the field in the temp table, then update the original table with...

Jason-299789 (10/7/2011)

---

The code sample in this link should help. http://www.codeproject.com/KB/database/splitparameterstring.aspx

The only difference is that instead of using a comma seperated list you use a # delimiter.

One minor tweak could...

Lynn Pettis (10/7/2011)

---

Sean Lange (10/7/2011)

---

paul.t.silvey (10/6/2011)

---

Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID...

paul.t.silvey (10/6/2011)

---

Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID column was added at...

The usage would be pretty much the same as the function you posted. It receives a delimited string and the delimiter and returns a table. The big difference is performance....

You REALLY should look at Jeff Moden's article and method for this type of thing. It is set based and does not use looping at all which means it is...

Oddly enough I happen to have an example of exactly what you are looking for. I think it was Gus who suggested that I should write up an article on...