You need to use a calendar table or a tally table as the main table for your query. You need to have a row for the date when there are...

Like this:

select RefNumber

from YourTable

where RefNumber not in

(

Select RefNumber

from YourTable

where EntryType not in (0, 2, 11)

)

prathibha_aviator (4/4/2013)

---

i was trying to solve an online test... and i stopped here... i tried looking at the newly introduced functions of sql server 2012 but could n't find an...

Your question is almost verbatim the MSDN definition of SOUNDEX. http://msdn.microsoft.com/en-us/library/ms187384.aspx

Now with the two phrases you listed the SOUNDEX would not be even close because the order of the words...

Since you say are new to sql. Looping and cursors are notoriously slow. When possible a set based approach will perform a lot better than cursor in most situations. There...

Glad to know it is working and thanks for the feedback.

erikd (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

There is...

http://msdn.microsoft.com/en-us/library/cc627369.aspx

5280_Lifestyle (4/3/2013)

---

As for the ANSI joins, when I tried switching to ANSI some of the rows were left out. With the old outer joins, the output was 243 rows. With...

Given the lack of details it is very difficult to offer much assistance here. I don't really understand why you have the subquery at all. I would also recommend that...

+1

Not only is it a reserved word...

Awesome job posting ddl and sample data along with desired output.

This produces the output according to your sample data.

select date, SchoolID from #temp

cross join #temp2

order by #temp2.SchoolID, #temp.date

erikd (4/3/2013)

---

Sean Lange (4/3/2013)

---

Using your dynamic code as an example this will produce the same results but as a single query instead of 1 query for each column.

declare @thing...

Using your dynamic code as an example this will produce the same results but as a single query instead of 1 query for each column.

declare @thing nvarchar(max), @table sysname...

bpowers (4/3/2013)

---

I built a staging table and I am writing the last execution time of the sp to that table. How do I now use the execution time in the...