Elliot kick *** giving us the sample data to test with!

don't know how close it is to the original posters, but i got similar results whether i choose t1.ZipCode or...

an index scan is not really a bad thing; much better than a table scan.

I think it depends on the selectivity of the index in question as to whether you...

ok I was playing with this today and found that i somehow broke the code for an computed columns;

I fixed and tested the solution, and here we go again:

here is...

ahh;

thanks Dave; That got me jump started so i could make a 1-to-many table that i was fishing for.

Thank you again!

the default trace only shows DDL statements...create table/proc/alter/drop, for example.

you need a separate trace running for DML statments like select/insert/update/delete.

log reader like apex is the way to go here.

i may be wrong, but i thought a linked server only allows DML (data manipulation and no DDL; you can't create a temp table, nor use the "SELECT... INTO NewTable...FROM"...

Elliot thanks, I'm looking at it now, if i get it to work i'll add another version;

sarodude, thanks! i had it working, then was trying to find the right column...

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