Search results for query: *

Ok....so i have been beating myself up and i have been crosseyed enough to put my head down and ask for help...it has defeated me and i need some guidance. here goes: i have two databases that i would like to update eachother when variables change from one to the other. right now i am going...

OK...i have a query i was hoping maybe someone can graciously assist me with...the scenario is this... I have a table that has customers that make regular payments. for example sake lets say that there are 6 columns like this in the payments table payment_id customer_id paymentdate...

Hi, I have an office that has two ISP's, T1 and DSL. I have been confused on how to set up the network for the the managers and for the sales agents. Here is what i have. the T1 handles all the Voip stuff and some minimal internet usage for the sales reps. the reps have one ethernet line going...

Can someone please look over this code and tell me if there is anything that they can recommend to speed it up...I have all the qualified fields indexed or clustered and the thing is, it runs fast (<1 sec) if i run it without the last line: "AND A.zipcode is null", otherwise it runs for 3.5...

I have some large tables that i have as log/history file entry tables. The tables contain anywhere from 10 million to 50 million records that do not have a unique key as it is not necessary but have a clustered index on the account number. this is not a unique key, but could be if i add the...

Hi All, I have a package that selects some data, inserts it into a staging table, then exports the data to a file which has the filename appended with the current date and some global variables...I would like to have the query that pulls the data out of the staging table to loop and ultimately...

Hi All, THis one has stumped me a bit...I have a table that has customer info in it and i have the address in an address table that has 3 types of addresses contained within: Current, Billing, and Installed... I have never had to create this report and thus am a bit stumped...I want to return in...

hi... i was hoping for a little help with a quey that is presumably an easy write but it is missing me right now... here is the query i would like to run but it is incorrect obviuosly: select distinct npa_nxx_id, zipcode, city, state from npanxx join zipusa on zipusa.zipcode = npanxx.zipcode...

Hi all, i have a large database with 150 million records that i want to pull 1 mil random records. i tried to order by newid() and this caused my tempdb to fill up after running for 33 hrs...anyone have any ideas on how to generate some random results...this is a consumer contact database used...

Hi all, Is there a way to select a certain range of results? I have a large database (75 million rows) and when I get a result set it is usually about 200k rows...if I wanted to select the top 50K that would be just a top 50k statement but what if I wanted row 50K through 100K....i was hoping to...

Hi all, I have a table with approx 75 million rows of names and addrersses in it that I am trtying to update...so far the update is running 5 hours and with no end in sight...a liitle background is that this is running on a quad zion 500 with 3 gb ram ands one 145 gb drive (boooo) without...

Hi All, I have a log file that has an operators duration on a phone...I import this currently as a char field and shows up as 7:22 or 14:33 ....(mm:ss)....I was needing to tally the totals up and was having a killer time converting this to a sumarizable format....Any Ideas??? I'd like to make it...