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...

Don't think so. What happens when you try running it in SSMS?

Nope, I am sure what I heard was normalization. I understand denormalization. I am aware of up to 6th normal form (no nulls).

What do you want to trigger the job? does it only run once a day?

NotManyPoints (2/3/2009)

---

If a DBA has:

a) no idea about the particular topic of SQL injection (particularly this topic, as its so widely written about -which is not the same as acted...