Search results for query: *

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.

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

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.

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

typo: computer=computed :)

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>

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

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

serach for bcp utility on books on line.

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

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

lol

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' )

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

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

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.

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

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

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.

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