Search results for query: *

I just received data back from a data recovery company and they put our recovered data on a scsi drive. hen i plug this drive into our server (one of the empty slots) it doesn't register in the OS. I think I have to enable it on the SCSI controller, but doing this will force me to create a...

I am new to filemaker pro, and i'm trying to dedupe some records that are in a database i've inherited. Is there a way to use filemaker's scripting language (similar to sql)? the table i'm working with is fname, lname, addr, text1,text2. There aren't exact duplicate entries, but the same...

i'm a bit new to this, but i'm trying to create a report that runs top to bottom with grouping on the left side and then when it gets to the end of the page it starts again on the top on the right hand side of the page. for example a page would look like this: ID Product order amount...

Never mind I figured it out. I ended up deleting the username that had been associated with the database added it again associated it with a login and it worked fine.

There is a SQL dev server we have that crashed over the weekend. there wasn't a backup of the OS HD just of the raid array where all the sqlserver DBs are located. After rebuilding and re-installing sql server, the dbs were successfully re-attached. When I create a user (the setup is mixed...

Sadly, I am the systems admin there is an external ip address and i can prove that because this server ahs an ftp site and i can also remote desktop into it (externally).

I thought I had narrowed this down to being a firewall problem, but i think it goes beyond that. Trying to give someone from outside the intranet access to a sql server, but when i test the dsn connection it doesn't work. When I change the connection to point to the servers internal ip...

Thanks George, that worked Great! I've run plenty of queries in the past with the added criteria in the where clause after the join and they've worked fine, any idea on why it had to be done this way? Also... is keeping everything in the on clause "proper"/standard? Just trying to get better.

I use various different outer joins frequently, but for some reason i can't figure this out. select y.lname,y.fname, count(distinct phone), count(distinct familyid) from TownTbl x full outer join (select distinct lname, fname from nametbl) y on x.lname= y.lname and x.fname= y.fname where...

I just installed SQL Server 2005, where do i find the query editor? I can get into the Management Studio and run queries there, but isn't there supposed to be a program similar to Query Analyzer from 2000?

I understand that the cost of a NAS (with Gb NIC) is much less than building a server with an internal/attached storage array. But I can't help noticing that most NAS's use SATA HDs that run at 7,200 RPMs. How much better would performance be on a file server that MANY people were using if it...

Thanks a lot, that helped. if i wanted to do this with all of the different HHIDs in the table and make one long list, how would i do this? if i create a cursor it would just run each statement seperately no?

To add more... Some sample data would be UniquID, HHID, Fname, Lastname,.. ToBeUpdW/allNamesinHH ======================================================= 0001 1000 John Doe Null 0002 1000 Jane Doe Null 0003 1000 Bill Doe Null I want to have it look...

Sorry if the title is a little confusing, I have a table that has multiple people per household with a household identifier. I'm trying to update a column in the table with all of the names from a given household concatinated together for mailing labels. the table layout is as follows...

thanks again for the help

I have a formula field that does some multiplying and adding with different fields that are integers and then adds text to the end. the numbers always appear with a .00 at the end. is there any way to stop this from happening? I tried truncate, but that didn't work.

I just started using crystal and I have it linked to data in a database. Each record contains statistics on a given store and each store needs a narrative written about it. I'm having trouble getting a new store to appear on it's own page, and I can't figure out how to get each store (there...

first off there may be a better way to do this, i'm not sure. i'm trying to build a crosstab query off of a bunch of different count queries joined together by unique values. There are 10 total queries being joined, but only one of the queries returns all of the values the data needs to be...

I have a Table that has over 6 million records. I need to append data from other tables to this table where they share the same zipcodes. All of the updates I am doing are based on many to one relationships and the update queries have taken over 3 hrs to run. I'm trying to find a way to speed...

I have a Table that has over 6 million records. I need to append data from other tables to this table where they share the same zipcodes. All of the updates I am doing are based on many to one relationships and the update queries have taken over 3 hrs to run. I'm trying to find a way to speed...