Can you some ddl (create table scripts), sample data (insert statements) and desired output based on your sample data? It is unclear to me exactly what you want and I...

What is the question?

earnest.williams (1/29/2012)

---

ok so here is what i came up with, can you guys tell me how it looks?

A death date preceding a birth date

ALTER TABLE TableName

ADD CONSTRAINT constraintname

CHECK...

tommy.ray (1/27/2012)

---

This only shows one property.

I want to be able to show all the properties in the database and if they have one picture or 20 pictures i want to...

Something like this get you close?

--Note this is untested because there is nothing to test against.

SELECT top 1 m.[property_id], m.[Address], m.[City], m.[Zip], m.County, m.Bedrooms, m.Bathrooms, m.HalfBathrooms,

m.[V_O], m.[Stars], m.Rehab, m.Open_bid,...

Good point Gus. At least my first suggestion wasn't flawed. 😛

Not sure what answer the interviewer was looking for but a couple of things come to my mind. First open the spreadsheet and compare row count from the spreadsheet to...

It is certainly a...

Around here these are never marked as "solved". The same problem you have may well come up again for someone else, or somebody else may stumble across this and the...

Jack Corbett (1/27/2012)

---

earnest.williams (1/26/2012)

---

I'm a student and a newbie with databases. I was wondering if anyone could provide me some information on constraints. What would the...

SQL Kiwi (1/27/2012)

---

Ah, I see. Thank you. Actually I know very little, but what I do know...

You can cast to varchar(max). Does that get you in the right direction. If at all possible you should consider changing your datatype to varchar(max) instead of text. The text...

No problem. Sorry it took so long to get through my thick skull what you were looking for. 😛

Something like this help? http://msdn.microsoft.com/en-us/library/ms177463.aspx

I don't know what I need because I still have no idea what YOU need. What is it that you need help with?