Viewing 15 posts - 22,606 through 22,620 (of 26,486 total)
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.
February 4, 2009 at 9:54 am
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...
February 4, 2009 at 9:52 am
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...
February 4, 2009 at 9:48 am
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?
February 4, 2009 at 9:45 am
You need to explain the requirements better. Looking at your expected results doesn't really make much sense.
February 4, 2009 at 9:41 am
Perhaps instead of Global Temporary Tables (##) they could use Local temporary Tables (#).
February 4, 2009 at 9:28 am
rpatil22 (2/4/2009)
Consider Today's date - 02/04/2009
So 3 months back date is - 10/04/2008.
so i want to delete rows from...
February 4, 2009 at 9:26 am
Agree with Luke I do, not enough info to help.
February 4, 2009 at 8:28 am
So, rpatil22, answer the question are you? Help you I would like.
February 4, 2009 at 8:20 am
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...
February 3, 2009 at 3:33 pm
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...
February 3, 2009 at 3:31 pm
Don't think so. What happens when you try running it in SSMS?
February 3, 2009 at 3:15 pm
Nope, I am sure what I heard was normalization. I understand denormalization. I am aware of up to 6th normal form (no nulls).
February 3, 2009 at 3:11 pm
What do you want to trigger the job? does it only run once a day?
February 3, 2009 at 3:08 pm
NotManyPoints (2/3/2009)
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...
February 3, 2009 at 2:38 pm
Viewing 15 posts - 22,606 through 22,620 (of 26,486 total)