the trick is to use the datediff and date add functions

for example here's how to find the first day of "this" quarter, ,and the previous 4 quarters based on today:

--First...

i've got a couple of questions related to the same issue.

what is the definition of "Recent Posts>>Posts Added Today"

i just replyed to a post from 5 days ago, and it...

glad i could help sam; let me know if this wroks out for you.

you posted in a SQL 2005 forum, so you got 2005-specific examples.

it's not object_name that is stopping your script...it's sys.columns:

SELECT OBJECT_NAME(id) from syscolumns where name ='ORDERID'

will work in 2000

aain, you'd use one...

all objects are in the system view sys.objects

so you'd simply do SELECT * FROM sys.objects where name like'%BIZ%' for example.

Nathan thanks for the feedback; having a different pair of eyes helps so much shaking down a proc like this.

#2 and #3 on the list of the things you identified...

davidlcrooks (10/13/2009)

---

Sorry for the lack of details. You are close.

I have a view with some data.

I want to create an empty table with the same structure...

little too thin on the details to offer any help so far;

what does the filename have to do with anything?

I'm trying to read between the lines, so help me out...

ahh ok...you know your data better than us, of course...so if you have 400 identical tables, one for each client, that makes sense.

it's fairly easy to generate a script to add a column to every table in the database.

--company and will have a default value of FPO

SELECT

'ALTER TABLE ' +...

you can add favourodily25 to the list of spam accounts; i just re-enabled PM's from t= he forum, and got a couple from that log in.

glad i could help;

that one section of the case statements i just wasn't sure about...you obviously know your data better than anyone, it just seemed like it might be a...

to do this FROM SQLExpress, the table you are going to import into must already exist.

in that case, you can add a linked server on the SQL Express to Oracle,...

wow;

your issue seems to be you haven't recognized you can get all the values in a single select statement; there was no reason(or logic) to try to get each value...