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: *

  • Users: RAS56
  • Order by date
  1. RAS56

    CallPilot locks up outlook

    I am having the same problem as InsCall and the solution posted by RSERNAJR makes my computer go ahead and open Outlook after 10 or so seconds as RSERNAJR indicated. I have looked for the setting suggested by Janeenaj and cannot locate anything like it - does anyone know anything more about...
  2. RAS56

    Is it possible to modify Tiff tags in images stored in image fields?

    Right, I realize that extracting the image to the client, writing the tif tag and then overwriting the image back to the blob is probably the most straigtforward but it incurs a lot of overhead in terms of network traffic. Potentially, we could need to do this to thousands of images frequently...
  3. RAS56

    Is it possible to modify Tiff tags in images stored in image fields?

    We have a bunch of .tif images stored in records with an image field. We are needing to update/add a tif tag to each of these images. Can anyone point me towards any libraries or methods of doing this server side and not have the overhead of moving the files across the network, modifying the...
  4. RAS56

    sp to reconcile rounding discrepancy

    ...percentages (costid,percentage) values (3,.24) insert into percentages (costid,percentage) values (3,.76) select x.costid, y.percentage, x.amount*y.percentage from costs x, percentages y where y.costid=x.costid and y.percentageid not in ( select max(percentageid) from percentages group...
  5. RAS56

    sp to reconcile rounding discrepancy

    ...table: ID percent 1 .50 2 .33 2 .33 3 .24 Then my caluculations would be something like cost * percent for each matching record in the percent table and cost - (cost * sum(percent) for id=id) for the percentage not covered by the percent table...
  6. RAS56

    MS Excel

    Here is a link to an article with a script that will use the sp_oa* procedures to create and write to an Excel spreadsheet as a linked server. The example works for me but it generates an error that I don't understand - it may be related to the fact that I'm running SQL2005...
  7. RAS56

    filling column with indices

    ...with id values based on col2 order insert into #tbl select col2 from testtbl order by col2 -- update sample table with id numbers update a set a.col1=b.id from testtbl a, #tbl b where a.col2=b.col2 -- display results select * from testtbl -- clean up stuff drop table #tbl drop table testtbl
  8. RAS56

    Images with Textcopy

    ...the image into the SQL DB is copying the raw image file, you may just need to use an image format that the tools you mentioned don't support. *IF* that binary file is a standard image file, you might try IRFANVIEW (www.irfanview.com) as it is seems to be a bit better at detecting the image...
  9. RAS56

    Select records less than todays date

    I think this would work: select hitdate from dbo.tblstatspagehits where convert(varchar,hitdate,112) < convert(varchar,getdate(),112)
  10. RAS56

    Default value for default constraints

    I have found the following help file to be helpful when trying to extract information from the server configuration tables. http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx It also comes on the CD with the SQL Server 2000 Resource Kit. I haven't located a similar...
  11. RAS56

    Case select question

    ...for a bit and couldn't make the dynamic field selection work. Something like this would work if your data structures would fit somehow: Select * from Table1 where f4 = case when f1=f2 then 3 else 2 end order by f1 but I don't think my previous example will ever work. -or- I think...
  12. RAS56

    Case select question

    Would this work: Select * from Table1 where case when f1=f2 then table1.f4=3 and table1.f5=2 else table1.f6=3 and table1.f7=2 end order by f1 I didn't test it but I think I've done things like this before.
  13. RAS56

    Emailing from SQL 2K

    One solution is http://www.sqldev.net/xp/xpsmtp.htm. I have installed it on several of our servers to use for notifications and it has worked without any problems. I was a bit like you when I needed to implement email support, the task seemed pretty daunting - this made it easy. One caveat...
  14. RAS56

    Loading the DTS Package

    Have you thought about loading the data as it is into a staging table and then processing the data to only import valid date values into your final destination. That should allow you to report on bad values.
  15. RAS56

    Server Management Studio save as problem

    I don't know if Express has this but in SQL Server Management Studio, it looks like you can set the output to Tab delimited under Tools | Options | Query Results | SQL Server | Results to Text | Output Format:
  16. RAS56

    Can I rely on table order in update command for concatenation?

    Thank you very much for spending the time to give me such a clear example. I applied what you showed me here to my actual example and it worked beautifully. My original solution with a stored procdure using a cursor looked like it would take several hours to run. The solution I posted at...
  17. RAS56

    SQL Server &quot;avg&quot; operator and decimals

    To me, this looks like a casting problem too. I tried this in SQL2005: declare @tmp1 int, @tmp2 int select @tmp1=3, @tmp2=2 select @tmp1/@tmp2 -- results: 1 go declare @tmp1 decimal(10,2), @tmp2 decimal(10,2) select @tmp1=3, @tmp2=2 select @tmp1/@tmp2 -- results: 1.5000000000000
  18. RAS56

    Can I rely on table order in update command for concatenation?

    Thanks for the tips. I had thought about creating a clustered index - thought that might help. I wasn't aware of the switch you mentioned - "and turn SMP off in UPDATE query with OPTION( MAXDOP 1 )." Will check that out. I hadn't thought about some kind of check column - I guess I could do a...
  19. RAS56

    simple exe client for inserts to mssql

    As was suggested earlier, you can use OSQL for things like this. The syntax is pretty simple. For instance, here is a command string to display a record: osql -S(local) -E -d my_data -q "select top 1 name from users order by name" Run osql -? to see the command line syntax. It is case...
  20. RAS56

    Can I rely on table order in update command for concatenation?

    ...set @combtext=isnull(combtext,'')+' '+isnull(@combtext,''), @combtext2=@combtext, combtext=case when edate>'!' then @combtext2 else '' end, @combtext=case when edate>'!' then '' else @combtext end -- display results select * from wrktbl order by key1,key2,eline drop table wrktbl

Part and Inventory Search

Back
Top