Please don't cross post. It just fragments replies and makes it harder for you and the people trying to help.

http://www.sqlservercentral.com/Forums/Topic1683510-169-1.aspx

heh seems that we have covered this before. Well done.

nick.latocha (5/7/2015)

---

Thanks for your reply.

The problem is the number of values can and will change - so my schema will also need to change each time a new value is...

Well are you using sql server or mysql?...

yusufm 48726 (5/7/2015)

---

Hi Guys,

I am kind of struggling to get the result for current date orders but I can get the query working for due date.

"

SalesOrder.DateEntered,

SalesLine.OrderQuantity, (SalesLine.OrderQuantity*SalesLine.SellingPrice / ...

spaghettidba (5/7/2015)

---

T-SQL is a horrible tool for this job and using the CPU of the SQL Server box to send pings is not a wise choice, generally speaking. Not to...

nick.latocha (5/7/2015)

---

I'm using a bitwise comparison to effectively store multiple values in one column. However once the number of values increases it starts to become too big for a int...

gwyn.jones (5/7/2015)

---

The problem with the database is that it is indeed a legacy system.

That field is actually a free entry field so a user can enter what they want.

The majority...

Maybe you are not able to cast as datetime because you have the dateformat different on your system then the format of the text version of your dates. This will...

gwyn.jones (5/7/2015)

---

Gazareth, yes very observant, you are correct Period - I mean customer_order_no - '01/01/15 - 20/01/15' etc.

I am adapting old code, hence the numerous substrings - I don't know...

gwyn.jones (5/7/2015)

---

I have a field called Period which stores a date range, i.e '01/01/15 - 20/01/15'

I can convert the first part into a start_date using:

substring(m.customer_order_no,1,2)+ '/' +substring(m.customer_order_no,4,2)+ '/' +substring(m.customer_order_no,7,2) as...

There are so many possibilities for an answer to this. Do you have any experience in sql server? Do you have any experience...

Yes. You should read up on database normalization. Having properly normalized...

Dealing with dates in sql is a topic that many people don't...

In Access you would create a new table similar to something like this.

create table ImageTags

(

ImageNumber number

, TagDescription varchar

)

Then for your example of "woman , beach , sea , seaside ,...