SQLalchemy (5/21/2014)

---

Is there a way to add a count of the occurances of my concatenated field "ConCatCNLN"

that have a count of 1 or 2 and just return a set with...

isuckatsql (5/21/2014)

---

What would be the best datatype to cast to,...

Nice job posting ddl and sample data in a consumable format. The biggest issue you have here is that you don't really have a base table that you can use...

aberndt (5/21/2014)

---

The report runs much quicker now that I have gotten rid of the unnecessary tables, fields, etc. but I've attached the execution plan for your review. I'm not...

RantaSanta (5/21/2014)

---

I have table1 with col1 varchar,col2 int , col3 xml , col4 bit

Can any one suggest a best way to fetch the col3 into file (.txt or .sql)...

aberndt (5/21/2014)

---

This works great, thank you so much. I can create a view to get the information that I need into my report but is there a more efficient...

sql_ques (5/21/2014)

---

Hi,

I need to select data where for a column is not equal to a value and also get the NULLs. The below query is not working. I can...

aberndt (5/21/2014)

---

Sean - This is great! Can I change the order of the data before the rowid's are assigned? I'd like to sort by WORKORDER_BASE_ID, then by WORKORDER_LOT_ID,...

aberndt (5/20/2014)

---

Thank you all for your help. Below is the final query that generated my view with the data I wanted to retrieve:

SELECT T1.ROWID, T1.WORKORDER_TYPE,...

You're welcome. Glad that worked for you.

Additionally you might want to check the datetime settings on your servers. I assume you are logging the error from your .NET application which is likely running on a different...

You have a...

aberndt (5/20/2014)

---

Below is the entire query. The statement provided by Lowell provides the desired results, thank you. How can I best utilize this data to create a view...

OK I get it. You are new to this. That is no problem. We can help with understanding. Did you actually read the article about how to post stuff? Did...

dquirion78 (5/20/2014)

---

Hi !

I'm converting access query to SQL Server

I have 7 reports in access

report #1 use a query A

report #2 use a query B that use date from query A

report...