AndrewSQLDBA (5/19/2014)

---

Hello Everyone

I hope that you all are having a great monday so far.

I am working with a large amount of text data in a single column. I am in...

rafael_si (5/19/2014)

---

Hello,

In our company we have a server (sql server 2008R2) with many databases including databases from a third-party software. The third-party software partner wants permission to see their process...

dquirion78 (5/16/2014)

---

Hi

I've conditional expression with IIF function and "=" in and view show me error in sql pane.

CTE is fine but I want able to use the query...

sharonsql2013 (5/16/2014)

---

I am trying to remove Null from my query but fail to do so.

There are around 20 different dept names in this table. But I only need to display...

Something like this?

CREATE CLUSTERED INDEX IX_CashReceipt_FY_Period on CashReceipt (FY, Period)

I would highly recommend that you click the Stairways link over on the left of this forum. In there you will...

dmandosql (5/16/2014)

---

Hi all,

Started a new job on Monday and I finally got access to development environment. Can anyone recommend a fast and efficient way to get used to the database...

PWW (5/16/2014)

---

There are no indexes; there is no primary key. I expect to always select from the table using the month and year fields. FY is the...

PWW (5/16/2014)

---

Thank you for your reply, Sean. This request is not due to a slow query. Both the reporting process and table are new. There are no...

PWW (5/16/2014)

---

I have a table that is used in reporting where once a month approximately 25,000 new records are added via a stored procedure. This will be cumulative over...

dquirion78 (5/16/2014)

---

Hi

l'll like to know the best way to call a long and complex query(Stored Procedures ??, table value function??, view??) from many other different SP and do some...

dcwilson2009 (5/16/2014)

---

Good point, Sean. I am going to have to think about that one. I don't think there would be 2 or more proc dates with the same DayKey, but...

kylemit (5/16/2014)

---

This answer uses a number of deprecated tables that will no longer be supported.

Here's a simpler way to achieve the same thing:

SELECT DISTINCT p.name AS proc_name, t.name AS table_name

FROM...

sharonsql2013 (5/16/2014)

---

I wanted to know if its possible to join something like this using multiple joins?

Select ......

From EntryInfo E

Left join ServerInfo S on E.Item = S.Item

Left Join CheckInfo C on...

alicesql (5/16/2014)

---

Thanks to everyone who took the time to help me with this. Sean, your comment about looking at columns instead of rows gave me a bit of an 'aha'...

This seems like a perfect situation to use EXCEPT. While the solution posted by Koen and the alternate yet just as viable solution from Igor will both work they both...