Answer Questions

• cshood Problem with ProClarity report 'Export' options

  Hi, all here, Thank you very much for your kind attention. I encountered a problem with export ProClarity reports. The problem is: under the ' E xport ' option, there is only 'Export to business reporter'. No other options like: ' E xport to reporting service', 'Export to PowerPoint', 'Export to outlook' which actually should be available for ProClarity report ' Export ' options tho. Would please any expert here give me any guidance and advices for that. Thanks a lot in advance for that. With best regards, Yours sincerely, Sorry, please ignore this post. With best regards, Yours sincerely, Hi, Pgoldy, Thank you very much for your guidance and help. Yes, I have had a look at the folder(C:\ ...Show All

• Subhasmita extending function: view dependencies

  So I have a number of separate databases on my SQL 2005 Server. I also have a number of Reports in SSRS. Many of the stored procedures in the various databases reference tables, functions, and stored procedures in other databases on the same server. How can I accomplish the effect of right clicking on a stored procedure for instance, clicking view dependencies, and having everything show up in that list, not just the items in that DB It is all stored in the database in one form or another, but I must be missing some crucial piece to integrating it all together. Note: I did not design this system, just maintaining and modifying existing items. There are no schemas to speak of. SSRS will most likely move to a dedicated server ...Show All

• Johan Nordberg Best way to generate script

  Hi! I have to make a program that copy a database structure. Right now i'm using SMO but it take a lot of time just to copy all tables. Here is what i'm doing: ServeurLocal.SetDefaultInitFields( GetType (Table), "IsSystemObject" ) For Each uneTable In BDConfig.Tables If Not uneTable.IsSystemObject Then NouvelleBD.ExecuteNonQuery(uneTable.Script) End If Next We have over 700 tables and it take me more than 5 min to copy all the tables and i haven't copy all the view and stored proc yet. The problem seems that i execute one by one each script. So i was wondering is there a way to stock all the script in some kind of object and then when the FOR is done execute this big script. Is it possible to create a ...Show All

• Spigot Security Fact Table

  Hi, I am trying to implement 'Security Fact Table ' approach in SQL Server 2000 / AS 2000. I need to do implement 'security fact table approach ' as a pilot / proof of concept to show that it works. I found the following article useful and followed exactly the same steps as described in the http://www.mosha.com/msolap/samples/Dynamic%20security.zip http://www.mosha.com/msolap/samples/Dynamic%20security.zip I am getting errors in the following MDX script as shown in the attachment. (the same problem with Microsoft support solution too ...) I have followed exactly the same steps described in the above download 131 Dynamic Security dwickert Script.doc document (Technique #2 Security Cube: Page 6 ). ...Show All

• Akshay Saini Time without date

  Hi I know there is no time datatype, but I need to store a time. I want store shift payrate change over times, currently 06:00 & 18:00. What is the best way to do this Ultimately I want number of hours worked each day 00:00 to 06:00 & 18:00 to 00:00 (bonus rates) and 06:00 to 18:00 probably to the nearest 1/4 hour as a decimal number. I am expecting input via a form in a time format eg 6:30 Is the best solution just to store the times as the decimal value of 0.25 & 0.75 and convet my input to a deciaml format TIA  using decimal will save space..and conversions...and u'll be able to index that column if needed (without worring abt it being gettin used as the case when u ...Show All

• Forscius creating a child row with two parents? (in one column)

  Hi! How can I make a relation that would let me relate an employee to two departments There is a table with emloyees and each one works in a department and there is a foreign key relation in the child (employees) table to the parent (departments) table. So can an employee work in two departments (it's not impossible to imagine, is it ) And how would I retrieve all the employees of a department Or in other words, if I were working on some kind of software for my local supermarket and they need to keep track of all bills they ever gave out. I would make this products table and this bills table. Then I would create a foreign key column in the products table and fill it with bill_ids from the bills table and make retrieving bill items a simp ...Show All

• HadaytUllah Left outer join query?

  Hello all, I am stuck in a bit of a mess, and i really don't know how to get out of it. I am a dot.net developer, working with MS SQL server 2000. I am trying to write a query which essentially gives the amount of stock available for a particular stock_code. select Stock_code, description from stock Now what i want to do is, for each one of the stock_code that apears in the table above i want to look into another table called pop_item, and get the closest delivery_date for that particular stock_code. So i have top 1 and order it by delivery_date desc. Individually for a particular stock_code, i can do this no problem. And here is my code for stock_code='E0016/6' select top 1 stock_code, delivery_date, order_number,qt ...Show All

• Zadoras Is "MARS" Supported

  Does the Compact edition support the MARS feature (multiple active result sets) of SQL Server 2005 No it does not, and it does not support multiple statements in a single command either. To be fair, MARS support was added in SQL Server Mobile 3.0. Unless you are using a previous version, it is very much supported. The difference from SQL Server here is that there is no flag that you need to set to turn this feature on/off. It is always 'on'. As mentioned above, batched sql queries are not supported. ...Show All

• BAZOOKAMEGATRON ERROR using GROUP BY

  Hi guys, The code below works fine if I take the "GROUP BY" Sentence out. Without the group by, I am getting something that looks like: Proj Nr Proj Name Proj Nr & Name 001 Proj 1 001 - Proj 1 001 Proj 1 001 - Proj 1 001 Proj 1 001 - Proj 1 002 Proj 2 002 - Proj 2 002 Proj 2 002 - Proj 2 002 Proj 2 002 - Proj 2 And I need only one line for each Proj, like: 001 Proj 1 001 - Proj 1 002 Proj 2 002 - Proj 2 (It is not because of the tables. It is because the Nr "001" is only a substring of the data) I thought I can use GROUP BY in order to get only one line for each Proj. This is the code I am trying: ...Show All

• Newbie Kam Can I retrieve a result set from a sp into a variable within a Execute SQL Task?

  Can I retrieve a result set from a sp into a variable within a Execute SQL Task I am passing the sql in a variable and have a resultset set up to retreive the output/result set from the SP. I am building it in a variable that contains exec sp_name '20071201' agentf1 wrote: Can I retrieve a result set from a sp into a variable within a Execute SQL Task There's a downloadable demo of doing this here: Execute SQL Task into an object variable - Shred it with a Foreach loop( http://blogs.conchango.com/jamiethomson/archive/2005/07/04/SSIS-Nugget_3A00_-Execute-SQL-Task-into-an-object-variable-_2D00_-Shred-it-with-a-Foreach-l ...Show All

• Mile Petrov How to read sql tasks and so on from a package programmatically??

  Hi everyone, Once I've accesed to package by means of LoadFromSqlServer method how to read its Sql Tasks, for example I'm trying with the Executables property but unsuccessfully results: pkg.Executables.Item(0) Thanks in advance, Thanks a lot for that. SSIS package traversal E xamples (in C#) are available in Microsoft's BI Metadata Samples download. Also, try out Windows PowerShell. It's essentially a .NET object shell with the ability to perform real-time Intellisense on objects (such a SSIS package objects). The following lists the package's top level Executables' properties. Its very minimalistic, but create a package with an Execute SQL tasks at the package level; then execute the belo ...Show All

• Ujjwal Karjee Custom Task Deployment

  Hello All, We have developed some custom tasks which we currently deploy the standard way. That is, we install the custom task assemblies in the DTS\Tasks folder and we also install the assemblies in the GAC. Due to some deployment practices we are trying to implement we would like to be able to remove the assemblies from the GAC and install them in some other location. I have tried installing the assemblies in the DTS\Binn folder, but this does not appear to be working. When I drop the custom control flow tasks onto the package's control flow tab I get the "Cannot create a task with the name ..." error. Is it possible to not have the custom task assemblies in the GAC Are there any tricks to getting it to work FYI, our ...Show All

• A.Russell Training a neural network

  I have two problems while trying to train a neural network. My network have 10 continuous input ad 1 discrete output (3 states) The parameters I chose are : -Hidden node ratio 10 -Holdout percentage 10 The others are default. First,when i train it thanks to BI dev studio, the training is very fast (less than 5 seconds) and the results compared with the training set are bad (at least 30% of errors). Is there a way to improve the training (I don't care about the time required to train if it works) Second, I decided to train the network using SQL server management studio and I get this error which I can't understand : "Les connexions ad hoc telles que specifiees dans des clauses OPENROWSET ne peuvent pas etre utilisees sur ce serveur&qu ...Show All

• Rajesh batchu CR + LF In Column Data

  I have CR+LF characters in my data and I would like to replace them with nothing. I am trying to us a derived column transformation to get rid of the character but I am getting errors. Here is what I have tried so far: REPLACE( [Column0],VBCrLf , "") REPLACE( [Column0],chr(13)+chr(10) , "") REPLACE( [Column0],char(13)+char(10) , "") Anyone have any ideas Thanks!!! Why not It really helps to provide error messages in this situation. -Jamie Thanks for the quick response but that did not work either. DOH! Yes, you need to include quotes. Like this: REPLACE( [Column0],"\r\n" , " ...Show All

• Daniel UJ What is the correct option for me?

  Hello there, I am not a company programmer but I do like to write programs for myself. I am currently looking at writing a Database program to track my DVD's, CD's Tapes and the likes (as well as quite a bit of other data). While discussing this with others it was suggested that I use MSDE (since it's free) and that way I could learn more about SQL databases at the same time. When I connected to the MS website to download MSDE I found that it will not be supported with Vista. Since I am planning on getting a new PC which will most likley come with Vista I am now wondering what would be the best way to develop my database. 1. Should I use Access (Since it will only be accessed across my home network) 2. Is there a version of SQL ...Show All