Answer Questions

• Steve Jackson CLR procedure implementation

  hi, i have created a class library to validate the pattern of regular expression. now how do i call it in an t-sql program so that the class library will read data from database and return the appropriate value i am trying to integrate the clr procedure.. but somehow i aint confident, about passing the parameters, chaman! Hi, there are several samples out there: http://msdn2.microsoft.com/en-us/library/ms131094.aspx (in this case with an additional output parameter) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• ernieracer PrevMember Question

  Hello, I am running into an issue where CurrentMember DOES NOT return all members at the lowest level. Here's my dimension Hierarchy --> [Week].[Week].[Week Name] I want to have it return the following when I select [Week].[Week Name].CurrentMember Week of 09/04/2006 Week of 09/11/2006 Week of 09/18/2006 But it is returning at the ALL level All Once I can return all members using CurrentMember, I should be able to use CurrentMember.PrevMember to return Total Revenue for the previous member, same as Lag(1). If anyone can shed some light on how to return all members at the lowest level using CurrentMember, I would truly appreciated! If there's an alternate way of NOT using CurrentMember, please feel free to let me kn ...Show All

• Leroyg Overlay of textboxes are not rendering properly

  In the page header I have a rectangle that has 2 textboxes on the same line and both are the full length of the page. One textbox has text centered and the other has text right justified. When I render report in Studio or print it, the text appears on the same line and justified like I want, but when the report is rendered when I call the report by URL, the textboxes wrap, like it's taking the width of each textbox in account. Has anyone seen this Any suggestions on how to overlay text on the same line and the text keep their own individual characteristics Yes, that sounds like that would work, but how do you format-center in the form-horizonally I do not believe that ...Show All

• Bernie West Joining Problem

  Hi I am having some problme with a join There is two tables a customer and orders The customer table has a unique list of customer The orders table fills up as they come in Customer Table ID Name 1 Cust1 2 Cust2 3 Cust3 Orders Table ID Customer Product 1 1 Tea 2 1 Coffee 3 1 Milk 4 2 Tea 5 2 Coffee So there can be multiple orders for one customer How would I show a list of customer who have never ordered 'Milk' I think this should be simpler and the output customer will be unique ( no double record ) select c.ID, c.Nam ...Show All

• ssmallfish Can't Install SQL 2005 Server Express Edition on AMD64 Processor PC.

  Hi. I am not able to install "SQL 2005 Server Express Edition " on my AMD64 bit Pc.. My OS is: Windows XP Pro (SP 2) Plz help me as soon as possible.. Mandar Raise a hand if you need more help. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Hi.. i use 2 get message that my service pack is not update though i have updated as I m using Win XP Pro SP2.. After some searching here n thr i got link of sql ..i dnt th proper link of microsoft from where i downloaded..and i hav installed it..its around 53 mb.. I saw some 64bit version of the framework. to install do i need 2 uninstall 32bit framework... i hav just completed ASP.net and VC# 20 ...Show All

• Benin Inserting existing Data from one Server to another Server FOR MS-SQL Server

  hi guys! i have this task to do, well lets say i have a DB in a Server lets say Server1 and i want to copy or insert this data to the Server2. Is there any easy way to do this copying the Keys automaticly What is the best way to copy the data Thanks a lot. novelle hi there! i think u misunderstood the question. im working in ms-sql server and have a existing db in one of the server. i want to copy the database to another server also in ms-sql server that means all the tables, primary key etc... is there any way to do it best i mean if i copy the data in one of the table to the server2 does it able to give its foreignkey the way it was before need help dont know how to do this! th ...Show All

• rapidexposure Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• S 007 SSRS 2005: Matrix in list causes blank pages in PDF

  I am trying to display data horizontally inside of a group footer of a table. I put a matrix inside of a list and then put that list inside of the table. Unfortunately, when the matrix grows, it causes the list to grow apparently and creates blank pages. I have to use the list to maintain the column width of the matrix. I found a MS article online talking about this problem in SSRS 2000, stating that it had been fixed with SP2. Does anyone know why this is still a problem in SSRS 2005 and how I can get around this issue This sort of problem seems to happen a lot when you place one data object inside of another one. I also encountered a problem before when I placed a table inside of another table. ...Show All

• Troy Lundin Backup to Share with SMO fails, but works to local hard disk

  I have a short program (vb.net) which backs up an SQLExpress database. It works fine if the destination is a file on the local drive. However, it always fails if the destination file is a network share or a mapped share. The same program verifies the share is available by trying to read and write a small file before performing the backup. This is a stripped down version of the code Dim svr As Server = New Server("Servername") svr.ConnectionContext.LoginSecure = false svr.ConnectionContext.Login = TextBoxBULogin.Text svr.ConnectionContext.Password = TextBoxBUPwd.Text Dim bkp As Backup = New Backup() bkp.Action = BackupActionType.Database bkp.Database = TextBoxBUDatabase.Text Di ...Show All

• Atlantaazfinest Add a calculated measure to a Measure Group ??

  I have created a calculated measure which is logically very much part of a specific measure group but I can't seem to work out how to add it to the measure group.. it just sits there as part of the general Measures. Can I specifiy in which Measures group it should reside This would also make more sense for managing Perspectives.. Hi Dave, how another property of Calculated member "Description" can be set Only with notepad   Thanks.. not exactly obvious is it! Hi, Here is how to relate the calculated memeber and the measure group 1. Open the calculations tab in the BI studio 2. Select the calculation (you want ...Show All

• Tryin2Bgood How to write Prediction Query using clustering algorithm?

  hi, I am having data like this Studid Date Perf 001 01/01/2008 90 001 02/01/2008 89 Cluster 1 001 03/02/2008 91 002 01/01/2008 75 002 02/01/2008 79 Cluster 2 002 03/02/2008 69 I wants to create two clusters cluster1 for studid 001. cluster2 for studid 002. How to write Prediction Query using clustering algorithm What do you want to predict If you want to "predict" the cluster label, the query should look like SELECT Cluster() FROM MyModel PREDICTION JOIN (<new data>) AS T If you want to use the predictive features of our Clustering algorithm (i.e. predict a column value), then make sure that column is marked a ...Show All

• ones81 Getting SQL result in a variable

  Hi there I have a global variable say cnt in SSIS package, now I want to get total number of rows from a table say emp in that variable cnt. how do we achieve that thanks and regards Rahul Kuamr Hello Rahul, You can use a row count transformation just before the destination component in your dataflow, you a have to declare a variable of type int32 and assign this variable in the row count transformation. Regards, Raju Thanks Rafael, you were right, just needed to find a new place to check the value of the variable, so played more with variables in Script Tasks and Componenets and got quite a bit more figured out. Had to learn about specifyi ...Show All

• Andy Wilbourn SSIS Designer freezing up when using the Debug utility !

  I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint If you have any suggestions or workarounds for de same plz do reply Thanks in Advance Shailesh Thanks for the quick response Phil . None of the child packages are copies of each other .... Though i will make sure that the GUID's are Unique Thanks again Shailesh Shailesh Chaudhary wrote: I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the ses ...Show All

• Docpro777 DateTime Column not using Index

  I'm having a hard time getting one of my tables to use a non clustered index that I have on a DateTime column. A sample version of the table is something like this CREATE TABLE Appointments ( ID INT NOT NULL, AppointmentDate DateTime NOT NULL ) with a clustered primary key on ID and a nonclustered key on AppointmentDate. This production table has over 1million rows and the problem I have is this: If I do a SELECT * FROM Appointments where AppointmentDate >= '20060701' AND AppointmentDate < '20060702' the Non clustered index on the AppointmentDate column works fine. i.e. I'm returning all appointments for the 1st of July. Now if I run the exact same query using datetime parameters, a Clustered index scan is perf ...Show All

• Evan Mulawski Differing results on identical systems.

  I have a staging environment and a developement environment set up on the same machine. Both environments consist of two databases, a staging area and a data warehouse. On the staging system when I run a query of the form: select count(*) from [StagingArea].[dbo].[saTable] join [DataWarehouse].[dbo].[dwView] on saTable.col = dwView.col join [DataWarehouse].[dbo].[dwTable1] on dwTable1.col = dwView.col join [DataWarehouse].[dbo].[dwTable2] on (dwTable1.col = dwTable2.col AND dwTable2.col = saTable.col) I get an answer returned in 2 seconds. When I run the same query on the developement system it never comes back with an answer (after 3+ hours). The data in both systems is identical. But it would appear that the query optimizer i ...Show All