skailey (7/14/2009)

---

While I appreciate the reasoning for why you would like certain questions posted this way, I believe it is overkill for my question. I have 2 tables. ...

Hey,

not 100% sure what you are wanting to do here, what output are you expecting? Is it just the first two values you are wanting output into cell A2?...

Still not sure if it's dynamic or not...? does RIGHT(ImageName,6) always equal either '_X.jpg' or '_Y.jpg'?

Very good article on pivots found at http://www.sqlservercentral.com/articles/T-SQL/63681/

Will there always just be two image types, X and Y? If so are they always named like '_X.jpg' and '_Y.jpg'?

Hi there,

I'm not quite with you... you ordered by date desc, but your output is not ordered, what is it that needs ordered by date desc?

You might find it useful to be able to check if table exist or not?

if so you can use something like:

IF OBJECT_ID('zzdbfiles.dbfiles') IS NULL

CREATE zzdbfiles.dbfiles ...

Hey, without some test data and table structures it's hard to provide a decent, tested solution, but I think you're overcomplicating things here a bit... why the nolock, why the...

declare @temp as table (txtdate varchar(10))

insert into @temp select '071009' union select '42209'

select

CONVERT(datetime,

case

when LEN(txtdate) = 6 then STUFF(STUFF(txtdate, 3, 0, '-'), 6, 0, '-')

else '0' +...

Cheers, thanks for the link!

Gail,

Is there any way to add an index to the function of a column? In Foxpro I am able to do things like:

INDEX ON VAL(SeqNum) AS Seq

Is there anything analagous...

This is code for getting a date without the time portion.

I'm not sure about actual performance, I'd need to test, however, the following keeps the date as a dat, without...

No bother, btw I really like this solution for finding the median, pretty neat. Will have a play around with large result sets when I get a chanace.

Apologies, missed that entirely.

If you calculate actual rate before you assign the row number the method works correctly.

I haven't investigated the performance hit on this, but if you do the...

Hey Steve,

this'll work so long as you are after the maximum value of prod, rather than the first.

I thought you said in an earlier post you are after the first...

Anyone want to help out here:

http://www.sqlservercentral.com/Forums/Topic731030-338-1.aspx#bm731057 I'm in wrong time zone to be any more help 🙁