dc.pc100 (9/30/2013)

---

How or where would i add the below

as lots of data gets messed up with dwains code

e.g

Destination File Name....sourcedata2

20130616.xlsx..............0616.xlsx

201307.xlsx.................07.xlsx

HSE.201306.xlsx...........HSE.06.xlsx

HSE.201307.xlsx...........HSE.07.xlsx

2013 ICT Calendar.xls....ICT...

T.Ashish (9/29/2013)

---

I have faced the same situation in an interview where interviewer asked me a question on triggers.

I tried my hard to convince him that we...

I find it interesting because I'm into self-flagellation and because it seems that all of the date formats you've included in your filenames CAST cleanly to a DATE data type,...

Running the code you quoted Jeff, I get these results.

sourcedata ...

If you're trying to unchain a sequence of part numbers using a parentID like this, you may want to look at using a recursive CTE to resolve the hierarchy.

Something like...

Ok. This should work.

But someone I'm sure will probably come up with a better way.

WITH SampleData (sourcedata) AS

(

SELECT '12 Jan 2013 Test.docx'

...

Post retracted. Hang on for a replacement.

Like Luis suggested, can't you just do a GROUP BY?

SELECT RunDate, FiscalYear, PP, Port

,OilPrice=MAX(OilPrice)

,GasPrice=MAX(GasPrice)

FROM @t1

GROUP BY RunDate, FiscalYear, PP, Port

Based on LinksUp's...

I included the intermediate cost and members columns so you could see that. Each is the...

I believe that it most certainly...

Knut Boehnert (9/27/2013)

---

dwain.c (9/27/2013)

---

Maddave (9/27/2013)

---

dwain.c (9/26/2013)

---

I love extended properties. Very comprehensive introductory article!

The only think I find annoying about them (unless I missed something) is that you can't update...

T.Ashish (9/27/2013)

---

Thanks Dwain.C

Kindly ignore my earlier post, I missed it completely. Actually, Other four solutions are giving accurate results

My results goes as below:

1.hunchback

WITH C1 AS (SELECT Shift FROM test12...

enriquezreyjoseph (9/27/2013)

---

EXEC sp_executesql @SqlQuery, N'@statusID=@statusID, @sexID=@sexID, @firstname=@firstname, @middlename=@middlename, @lastname=@lastname' -- one for each of your filters

,@sexID=@sexID

...

Maddave (9/27/2013)

---

dwain.c (9/26/2013)

---

I love extended properties. Very comprehensive introductory article!

The only think I find annoying about them (unless I missed something) is that you can't update them. Need...

Never seen that error but it looks like it is complaining about the typing of one of the parameters to your SP.