It's great, but do you understand how does it work?

You'll be the one in charge of this for any modification, correction or improvement, so you better understand it. Feel free...

I'm not sure on how to create the order you need, but here's an option.

Be sure to understand it and test it because it might get slow when working with...

Do a favor to yourself and use date data types when needed. Using numeric values (or even string values) will only give you headaches.

Here's a possible solution for you (I'm...

rodjkidd (3/13/2014)

---

I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%

A B A C A B

Just repeat until you...

This is certainly ugly, I might come back to improve this query.

SELECT at.Style,

STUFF((SELECT ',' + CAST( x.AmendmentID AS varchar(10))

FROM #AmendTest x

WHERE at.Style = x.Style

AND x.DT BETWEEN at.DT AND DATEADD(MI, 30,...

Could you explain the logic to obtain the expected results?

You need to ask for a complete script, not just the tables' scripts.

Every object from the original DB should be scripted in the proper order to avoid the problems that...

dwain.c (3/12/2014)

---

Luis Cazares (3/12/2014)

---

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've...

I can give you the script to create a "boolean" data type. However, it might not be the expected definition and you must ask for it with the person that...

You seem to have a problem with a user defined datatype (dbo.boolean). You need to create it before running the script or you need to change the script to use...

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that...

A replace can work for you.

SELECT REPLACE( CONVERT(VARCHAR(24),@deadline, 100), ' ', ' 0')

Sean Lange (3/12/2014)

---

Thanks Sean, it came after my third cup of coffee, I might need more now. 😀

I might be trying to kill a fly with a cannon but this could be an option. It could be turned into an inLine Table-valued Function if needed to avoid...

jownby (3/12/2014)

---

Is that like when Porsche wants to sell you...