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: dky1e
  • Order by date
  1. dky1e

    Line graph trendlines?

    Hi, I do need to draw trend lines in some of the reports. Is it just not a part of RS, or I just can't find it? I have a date field on the x axis, and two series in the data part of the report. I need to draw linear trend line. Thank you.
  2. dky1e

    Rolling Change Field

    Hi, Here's the data in the table id value 5 546 6 566 7 566 8 587 I want to add a "delta" column that will show the change between the current data and data above, so it would show: id value delta 5 546 6 566 20 7 566 0 8 587 21 Is it possible in RS...
  3. dky1e

    open space delimited file

    Thanks! I ended up writing a little c# console app to parse the input file and output anther file in format I wanted. Too bad, currently, you can't do it easily through sql--in other word, I cant wait for sql2k5.
  4. dky1e

    open space delimited file

    Hi, I need to import a couple hundred of files. From what I noticed, the files do not all have the same columns, but they all share three columns that I am interested in, ie "col1","col2", and "col3". Now I need to import these files, preferably not through dts into my table that contains the...
  5. dky1e

    add computed column - Merge Replication

    typo: computer=computed :)
  6. dky1e

    add computed column - Merge Replication

    Hi, I can't seem find a way to add a computer column in a replicated enviroment. It's a column that's a substring([othercolumn],1,100) <data_type> DEFAULT <constant_expression> IDENTITY <seed> <increment> NOT FOR REPLICATION ROWGUIDCOL <column_constraint>
  7. dky1e

    POST to http form from SQL Server

    Let me give more detail. I would like to write a stored procedure that sends a POST data to a webpage, and retrieves information returned by the page. This page retuns an xml text which I can open up using OPENXML, parse and update all the necessary fields in my database. I have a working...
  8. dky1e

    POST to http form from SQL Server

    Hello, I need to (form) post to a http web page, retrieve the results and put to a table's text field. I've tried using Msxml2.XMLHTTP object, but it either fails to post data or returns Exceptions. (no useful description) Any suggestions, samples, or alternatives would be greatly...
  9. dky1e

    Export to CSV file - via SP

    serach for bcp utility on books on line.
  10. dky1e

    OpenRowset &quot;Data cutoff&quot;

    I have a feeling that if you're viewing it through Querry analyzer, it will cut it off for you automatically. You can increase the cutoff point up to 8k (tools->options->results(tasb)->Maximum characters per column(text box). What happens if you do: SELECT datalength(member) FROM OpenRowset...
  11. dky1e

    Importing Multiple CSV Files Using DTS

    Create DTS package, call it YOURDTSNAME. Create two connections, one pointing to your file and call it 'src' and another one to the server, create a data pump task and set it up accordingly. Then dynamically change and source file name and execute the package using the code below: declare...
  12. dky1e

    Stored Procedure FROM clause

    lol
  13. dky1e

    Stored Procedure FROM clause

    Try this: SELECT dbo.tblMaster.FlitchNum FROM dbo.tblMaster WHERE exists( select 1 from dbo.tblDetail where dbo.tblDetail.FlitchNum = dbo.tblMaster.FlitchNum and tblDetail.UsedBy = 'mike' )
  14. dky1e

    List all files in directory

    I like to avoid shelling out to cmd, but I love simple solutions :)
  15. dky1e

    List all files in directory

    Hi, I am aware of master..xp_dirtree. How would I retrieve a list of all files in a folder? I've been playing around with Scripting.FileSystemObject Folder Object which returns a collection of Object File. Unfortunately I don't know how to get at each of the File(s) to retrieve Name...
  16. dky1e

    SQL Server write size

    Hi, From what I understand, SQL Server will write in 8kB chunks. Is it possible to change this figure? For example if I have a database where a lot of data gets updated in bulk, it might make sense to write more bytes in each page.
  17. dky1e

    Crystal to Microsfot Reporting Services Migration

    We already have an unlimited license of sql server, no per-seat license will apply for us (which is still a lot cheaper than CR licensing and maintenance fees), so it is a nice free upgrade for us. Regarding training, the report designer is a little diffrent from crystal's, but it is intuitive...
  18. dky1e

    Crystal to Microsfot Reporting Services Migration

    Mostly cost, but also bugs and overall pain to work with their objects (to implement row-level filtering, manage schedules, etc...).
  19. dky1e

    Crystal to Microsfot Reporting Services Migration

    Hi, We have made a decision to drop the Crystal Enterprise and replace with Microsoft's Reporting Services. I'd like to make this thread and information source for others aiming at the migration process. Please post any information, tool or utilities that can help accomplish the task, Thank you.
  20. dky1e

    verify if ENFORCE RELATIONSHIPS for constraints is on

    err, sorry... it should be 'CnstIsDisabled'

Part and Inventory Search

Back
Top