Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lsgtechuser

    Need Help Recovering Files on a SCSI drive

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

    de-duping records witha script

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

    creating multiple columned report

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

    cannot open user default database odbc error

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

    cannot open user default database odbc error

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

    Connection problems with a dsn

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

    Connection problems with a dsn

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

    Problems with an Outer join

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

    Problems with an Outer join

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

    stupid query editor question

    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?
  11. lsgtechuser

    Nas Vs. Building a server with an SAS array

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

    Updating records that share a common Identifier with multiple values

    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?
  13. lsgtechuser

    Updating records that share a common Identifier with multiple values

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

    Updating records that share a common Identifier with multiple values

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

    trying to get decimals to disappear in a formula field

    thanks again for the help
  16. lsgtechuser

    trying to get decimals to disappear in a formula field

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

    Idiot question about getting CR to display a new page for each record

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

    Problems with Multiple outer joins for crosstab

    ...like this: select B.[FIELDBLABLA], Acount, Bcount, Ccount, Dcount, Ecount, Fcount, Gcount, Hcount, Icount, Jcount FROM (select [FIELDBLABLA],count(*) AS Acount from myfile group by [FIELDBLABLA]) A , (SELECT [FIELDBLABLA],COUNT(*) AS Bcount from myfile WHERE .... GROUP BY [FIELDBLABLA]) B ...
  19. lsgtechuser

    Difference betw Primary Keys and Clustered Indexes and regular Indexes

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

    Difference betw Primary Keys and Clustered Indexes and regular Indexes

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

Part and Inventory Search

Back
Top