Viewing 15 posts - 10,426 through 10,440 (of 13,469 total)
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...
October 14, 2009 at 12:17 pm
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...
October 14, 2009 at 11:53 am
glad i could help sam; let me know if this wroks out for you.
October 14, 2009 at 11:46 am
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
October 14, 2009 at 8:23 am
John Paul-702936 (10/14/2009)
Thanks ..If you don't mind .. Can you tell me
Script to List of the Objects that uses a Specific Column name
aain, you'd use one...
October 14, 2009 at 8:12 am
all objects are in the system view sys.objects
so you'd simply do SELECT * FROM sys.objects where name like'%BIZ%' for example.
October 14, 2009 at 7:58 am
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...
October 13, 2009 at 4:55 pm
davidlcrooks (10/13/2009)
I have a view with some data.
I want to create an empty table with the same structure...
October 13, 2009 at 8:53 am
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...
October 12, 2009 at 8:06 pm
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.
October 12, 2009 at 8:35 am
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 ' +...
October 12, 2009 at 8:03 am
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.
October 11, 2009 at 4:47 pm
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...
October 11, 2009 at 3:45 pm
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,...
October 11, 2009 at 10:46 am
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...
October 11, 2009 at 10:34 am
Viewing 15 posts - 10,426 through 10,440 (of 13,469 total)