Gaius Baltar (2/4/2009)

---

Good Day,

I am working on a query for SQL Server 2005 and need some

help with a logic problem. I want to add to the WHERE clause

some...

It would also be nice if Paresh Prajapati would post back as well. I'd be curious to see if he has learned anything valuable from this post?

Well, there is a difference. This site is really just the "water cooler". It provides a place for venting, in an appropriate manner (no foul language), and if...

Magy (2/4/2009)

---

I have a query that I use for searching that contains a FREETEXTTABLE statement.

I now need another query to search another table, but this table is not text indexed.

I...

My title is System Administrator. I'm actually the Senior DBA and team lead for our database group. I report to the Director of MIS.

Based on your last comment, local temporary tables may not work. They are only good for the current session, and if the table name is being passed back to...

I'd be reluctent to change jobs right now. But then I work for a K12 Public School District, and it has some significant advantages. the first is that...

Again, this is PeopleSoft. What version of the software and peopletools are you using? Is this query maintained by the application or is it a custom query?

You need to explain the requirements better. Looking at your expected results doesn't really make much sense.

Perhaps instead of Global Temporary Tables (##) they could use Local temporary Tables (#).

rpatil22 (2/4/2009)

---

Table will contain data for a year (2008 and 2009) (400K+ rows)

Consider Today's date - 02/04/2009

So 3 months back date is - 10/04/2008.

so i want to delete rows from...

Agree with Luke I do, not enough info to help.

So, rpatil22, answer the question are you? Help you I would like.

I'd need a little more information regarding what you are looking for regarding the past 3 months. There are several ways to "read" that requirement. The last three...

I'd never use 6th normal form. Why would you want a table for evey column in your database? Think of all the joins you need to get the...