fergfamster (5/26/2016)

---

Ok, well i cant give you all my code. If you wanted to create an Inline function and have separate queries returned based on an IF statement is the...

fergfamster (5/26/2016)

---

hi Guys -

I am trying to create one function with multiple sub queries based on the param value passed in. If i try to use the IF statement I...

Lynn Pettis (5/26/2016)

---

peter.row (5/26/2016)

---

Sean Lange (5/25/2016)

---

So you are only going to keep 180...

Grant Fritchey (5/24/2016)

---

Sean Lange (5/23/2016)

---

Jack Corbett (5/23/2016)

---

Sean Lange (5/20/2016)

---

GilaMonster (5/20/2016)

---

Ed Wagner (5/20/2016)

---

ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for...

So you are only going to keep 180 rows out of 67,404,675 rows?...

gjuarez (5/23/2016)

---

Thank you for your quickly reply. So just to confirm the entire script would look like this, right?. Thanks again

DECLARE @days2keep INT

SET @days2keep =180

while @@ROWCOUNT > 0

begin

delete top 10000...

gjuarez (5/23/2016)

---

I have a table that contains an audit trail (changes made to the DB), this is a big size table. I created a job to delete all records except...

boughrogers (5/23/2016)

---

Hi Sean

Thanks for the advice I wasn't sure if it would have any performance impact but I can see this would as you advise be a bad idea.I...

boughrogers (5/23/2016)

---

Hi

I am looking to set up a view from a selection of other views and tables and grant access to a new login to only access this view.

I have...

Here is a great place to start. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D

Here is another way you can do this.

select *

from #Work

order by Case when ActivityCode IS NULL then 1 else 0 end

, ActivityCode

Soccer tournament this weekend so I...

Jack Corbett (5/23/2016)

---

Sean Lange (5/20/2016)

---

GilaMonster (5/20/2016)

---

Ed Wagner (5/20/2016)

---

ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017. I...

GilaMonster (5/20/2016)

---

And further...

No I didn't. I don't usually open Office documents from people I don't know. Too many nasty things can get hidden...