Answer Questions

• International Update column with 8 digit random number

  How can I replace a field for each row in my table with a Randomly generated 8 number value The field is of type int that I'm updating OK, didn’t see that it has to be reseeded on a row base, so that’ll be your solution: UPDATE MASTER SET SSN = RIGHT(REPLICATE('0',8) + CONVERT(VARCHAR(100),CAST(RAND(CAST(NEWID() AS VARBINARY(128))) * 100000000 AS INT)),8) select top 100 ssn from master HTH, Jens Suessmeyer. ...Show All

• sean_kirkpatrick Information/ErrorCode from FireInformation/Error

  Hi, Very low priority this one... Is there a "free" number range that we should use for the InformationCode/ErrorCode parameter to the FireInformation/FireError methods Currently I just use 1 and -1 respectively. On a similar note...I remember someone from MS (might have been Matt) once saying that a list of all the rror codes would be published at some point. Is this still the plan and if so, where will it be Thanks Jamie Jamie, I can r ...Show All

• emp Designing SSB queues, EA sample and unreliable interdependant NTFS tasks

  Our current project involved into managing NTFS hierarchical folders structured by multi-level customers and associated projects for them. Essentially each folder level represents one level of customer hierarchy or project root. Both have different subfolders and user access rights for them based on generic XML templates. The folders resided on file servers across the country and should be accessible in ordinary way NTFS file shares are allowin ...Show All

• CarrieW_MS Active (non executed) objects will still drain performance!?

  Even if objects(tasks, components) are not explicitly called (say they are under another CtrlFlow constraint which doesn;t meet expr_condition), they will still eat up performance. We have a pkg that has 3 DFTs that will either transform FLFFtoXML, CSVtoXML, or PIPEtoXML. When we execute this pkg it takes roughly 15 secs to complete, but for every DFT we disable, it shaves 5 secs off. We did some debugging and found that an entry of: DLLGetClass ...Show All

• luvly_girl How to sum all footers?

  I am doing a CountDistinct(JobItems) in one of my list groups. In the footer I want to have the sum of each of the CountDistinct I calculated above. I can't do a count distinct for the entire dataset because the JobItem I'm counting can repeat across groups and that would produce the incorrect number. Note: I'm trying to avoid writing custom code because I have a lot of things similar to this. Thanks for any help. If you need example data pl ...Show All

• Ming Ding Error attempting to import from Excel

  Here is the error: TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ The connection type "EXCEL" specified for connection manager "{55E5636D-F ...Show All

• brianbruff Tips on using the SQL Server Security forum

  I am collecting here a few tips on using this forum. The tips are actually pretty general, they're not really specific to SQL Server or to this particular SQL Server Security forum. 1. Verify that you are posting to the right forum. Check the list from http://forums.microsoft.com/MSDN/default.aspx SiteID=1 to see whether there is a more appropriate forum for your discussion topic. By posting to the appropriate forum, you will be able to get a ...Show All

• Kian Ryan how to order stored procedures or tables by date

  We used to do this extensively in the old enterprise manager.. this is needed on big systems with lots of tables and stored procedures becuase you normally don't remember the name but it is the most recent thing you were working on.. anyone know how to do this in the new sql server management studio.. thanks There is create date in sysobjects but there is no last updated date. So if you use alter procedure there is no trace. B ...Show All

• Magnesium The first axis of the query should not reference any dimension other than the Measures dimension?

  Hi, The first axis of the query should not reference any dimension other than the Measures dimension I am writing a MDX Query in reporting services and I cannot use any dimension other than the Measures dimension in the first axis. When I run this query in SQL Server management studio it runs well . Why not in Reporting Services Note that I'm using the SQL Server Standard .The error is : ------------------------------ ADDITIO ...Show All

• szerencsi Working with Linked Servers

  Hi, Iam new to exploring the linked servers of MS SQL SERVER 2000, and i had created linked server (Oracle DB) and trying to insert record into linked server whenever a new record is inserted into a SQL Server database table. For that reason i have created the below described trigger. CREATE TRIGGER TEST_TRIG ON ORACLE_TEST FOR INSERT AS DECLARE @EMPNO VARCHAR(10) DECLARE @REMAKR VARCHAR(30) ...Show All

• admeralthrawn Prediction with many attribute states

  I have a large dataset of around 3 million records with accounting data for 2 years. Attributes are transaction amount (cont. / predict), account, cost centre, project, month and a few others. I want to predict any future transaction amount for a certain combination. For example; what will the next salary cost transaction amount in cost centre 123 probably be I have tried Decision trees and Neural nets. But the predictions are not go ...Show All

• wrightti Default Schema and Synonyms

  database0.User1 has a default schema of database0.Schema1 and also belongs to database1. I have the following synonyms in database0: Schema1.Customers - points to database1.dbo.customers dbo.Customers - point to database2.dbo.customers User1 has execute rights in database0. I have a stored procedure in database0 that says select * from Customers I thought since User1's default schema was Schema1, it would automatically see ...Show All

• Donovan Smith - MS Avoid splitting trees by value missing

  Hi, could anyone kindly let me know how to prevent the Decision Trees model from using value missing as a criterion to split trees Thanks, hz Unfortunately there's no way to not split by a value that appears in the data in SQL 2005. It's something for us to think about for future versions (expecially the "NULL" case) Yes, unfortunately, there are a lot of null values. I am not sure what you mean by "use NOT NULL ...Show All

• Carl213 RE-Using passed parameters

  Hi All  I link to a report passing parm a,b,c (3 parms) a (Hidden), B(Multi Selection), C(Single selection), the report display correctly  and the parm selection boxes display with available options. I would like to be able to choose from the selection boxes and replace the initial (passed parameters) B and C would have a new value, and display the same report using the selected criteria. Thank you Trentino &nb ...Show All

• Jerry D Issue with SqlUserDefinedAggregate

  I am using the code below but I am getting a "zero" result for dbo.AggredIssue('Test') user defined aggregate everytime that the query executes parallel processing and uses the "Merge" method. It seems that my private variable " private List < string > myList" gets nullified everytime it goes through the "Merge". I saw other people reporting the same issue in other forums, but nobody was able to provide a solution or explanation. S ...Show All