Answer Questions

• GTrz Current month minus current day

  Beginners question: I am using a calendar table joined to my data table so that it will give me all the dates regardless wether there is data for that day or not. Now, I want it to give me all the data from the current month minus the current day. Right now I am using (MONTH(c.dt) = MONTH(GETDATE())) AND (YEAR(c.dt) = YEAR(GETDATE())) but that also gives me data for the current day which I do not want. Any way I can make this happen Thanks Awesome. Thank you very much Chris. Thank you Chris. That will indeed not give me the current day but it also does not show me the current day with a null value. I still need to see the current day just not with any data i ...Show All

• Quick x Scope using the cache from one report that was created by another report

  I have two reports, the formatted report and the unformatted report. The formatted report has a link to the unformatted report which essentially is the same report but with no totals our grouping, and was designed so that the user can dump data to Excel. Also the unformatted report is hidden from the user and can only be run from the the previously mentioned link. The formatted report is driven by sql that is dynamically created and when the user clicks the link, it passes this sql to the un-formatted report and re-runs the exact same sql. My question is, is there a way to have the unformatted report use the cache from the formated report and thereby avoid re-running the sql. ...Show All

• Mark Macumber SSIS: First Time Script Component

  Hello, I have a flat file that contains detail in each record as indicated below: HEADER_ID, ATTRIB_A(1..10), ATTRIB_B(1..10), ATTRIB_C(1..10), etc. The index of the attribute relates it to other attributes with the same index. It needs to look like this in the detail table: HEADER_ID, ATTRIB_A1, ATTRIB_B1, ATTRIB_C1 HEADER_ID, ATTRIB_A2, ATTRIB_B2, ATTRIB_C2 I need to pivot these attributes into a detail table that relates back to the header information. Because of the number of these, I don't want to use the UNPIVOT Task because there are so many. I was hoping to move the complexity to a Script Component where I could read one line and transform it to a normalized state. Can someone point me in the right dire ...Show All

• plinius How do I update a field only if update value is not null?

  Hi. I'm not  such an expert in sql and I wanted to update a table's fields only if the value that im going to update it with is not null. How do I do that What I mean is something like: --------------------------------------------------- Update database.dbo.table set if(@newvalue !=null)      afield = @newvalue; -------------------------------------------------   Really need your help on this. Thanks. Right now, I figured it would be something like this: UPDATE Crmworks . dbo . Lead SET Lead_PersonFirstName = @firstname WHERE Lead_LeadID = @syncid and @firstname is not null -- UPDATE Crmworks . dbo . Lead SET L ...Show All

• Gulden Running both RS2000 and RS2005?

  We are currently running Reporting Services 2000 with the Report Server on one machine and the ReportServer database on a different machine. We want to upgrade to RS 2005, but some of the reports will need to stay on RS 2000 (they are owned by a different dept). I know you can run RS2005 using a SQL Server 2000 database, but can you run RS2005 with SOME reports on a 2000 database and OTHER reports on a 2005 database If you can, how do you go about upgrading the report server so that it points to one (2000) database in one circumstance and points to another (2005) database in another circumstance Thanks for your help! Nancy Let me clarify the various options you have and what they actually mean. ...Show All

• John Veson DB connection from file vs local SQLServer instance

  I want to add a data source to a C# project that comes from a local SQLServer instance. But when I attempt to do a new connection, it only allows me to specify a file . That is, the only choices I have to select a data source type are "Access DB file" and "SQL Server DB file". I know that with the non-express VS edition there are more choices available. But reviewing limitations of express editions on the web, I find a frequent mention that one cannot access remote data, only a locally installed data source. But is not a SQL Server instance on my local machine a local data source This is an issue because if I proceed with connecting as a file, then VC#Express complains the file is in use. If I first go into SqlServe ...Show All

• VIKI esquire Errors loading a text file into a Sql Server Destination

  I am trying to load 14+ million rows from a text file into local Sql Server. I tried using Sql Server destination because it seemed to be faster, but after about 5 million rows it would always fail. See various errors below which I received while trying different variations of FirstRow/LastRow, Timeout, Table lock etc. After spending two days trying to get it to work, I switched to OLE DB Destination and it worked fine. I would like to get the Sql Server Destination working because it seems much faster, but the error messages aren't much help. Any ideas on how to fix Also, when I wanted to try just loading a small sample by specifying first row/last row, it would get to the upper limit and then picked up speed and looked like it kept o ...Show All

• James S Lapalme How To Tell the Version of Reporting Services?

  Dear all, I encountered a problem on downloading large Excel file from Reporting Services 2000 . And I know that lots of people have asked the same question before. Does this have anything to do with the version of Reporting Services 2000 (Enterprise/Standard/Developer) How To Tell the Version of Reporting Services on Server 2003 Thanks for your precious reply. Go to the /ReportServer virtual root of the report server, e.g. http://ServerName/ReportServer At the bottom of that page you will find a version number. If you are running SQL Server Reporting Services 2000 RTM, you will see: 8.00.0743.00. If you installed SP1 or SP2, you will see a higher version number. Particularly for Excel export, there was a chang ...Show All

• Rattlerr Matrix subtotals

  I have this: 2003 2004 2005 Total cars apples cars apples cars apples Tom 3 1 4 2 5 1 16 Sally 0 2 4 1 7 6 20 And I need the last column (the group subtotals) to be like this: Totals cars apples 12 4 11 9 So basically, the question is, how do I get the second column-group (cars/apples) subtotals to appear in the last column As seen, the the subtotal for the first column-group (year) is meaningless. ...Show All

• dmsy Restore Databases in AS 2005 from CAB Files created in AS 2000

  I have to restore some analysis services 2000 databases on AS 2005. Is there some tool which can perform this I have CAB files being created by another team. Previously i used to restore them on my SQL 2000 Analysis Services using msmdarch. Now i am planning to upgrade to SQL server 2005. But the team which creates the CAB files will continue to be on SQL 2000 Analysis Services for at least 6 months. Therefore migrationwizard will not be helpful in my case. (I don't have access to their SQL Server or Analysis Server databases) If your machine already has AS2000 installed, you could install AS2005 on the same machine as a named instance and then ...Show All

• Scott Boyd can a database be made full after 15 entry's

  Hello guys I was wondering if it would be possible to make a database full after 15 entry's and how would I go about doing that if it is possible Thanks Again Rob I really appriciate your help I was messing around with the code you gave me today but I am confused on where to put it/Implement it I went into the table and tried to add a check constaraint but I couldn't get the exception accepted ;-( Sorry to be a pain in the arse Hi Warren, The (VB) code you've been given above won't really help you as it doesn't really provide any mechanism to enforce your rule if the application is bypassed for data operations. As an example, say your table you want to limit the number of rows for is called t15: create table t15 ...Show All

• Steadyonabix SSAS re-deployment failed after import - blank error description.

  Hi, I have created a new project using the "Import Analysis Services 9.0 Database" from the server and moved the project to my local pc (not connected to the server) in order to use the metadata. I can't deploy the new project on my pc to the local AS database. BI studio says: Deployment failed The following system error occured: . (only a dot) Can I get hint First see if your local Analysis Server is runing. Try connecting to it using SQL Management Studio. Second. Right click on on the solution in BI Dev studio -> Properties->Deployment. Check out the server name. To deploy to your local machine you can use machine name or localhost as a sever name. Edward Melomed. -- This posting is ...Show All

• Equis Endpoint Security ?

  Hi There I am trying to grasp endpoint security, or actually more security/certiicates in general, at the moment i am trying to write a distributed service broker app, all the examples i have seen use certificates for the endpoint authentication. Why must one create a certificate at each endpoint Why can i not create a single certificate and let all endpoints use it As you can imagine of this app gets distributed to hundreds of places creating a certificate at each one is a mission So can i use a single certificate for all endpoints authentication Thanx The certificates based authentication (in general, not only for Service Broker) relies on the fact that the private key is a well guarded ...Show All

• jmurray_mi SQL Reporting Services..

  Hey guys, Is it possible that a report viewer on VS2005 to send an email manually w/o using the subscription services Also, is it possible to preview a reporting services(2000 Version) to a VS2005 report viewer Thanks in advance.. Search this newsgroup for "render and save" there are links to code samples to do this. Daryl Hi, thank you for your prompt reply. I appreciate it. Just wanna know how you were able to render it to the appropriate format. Can you provide some code Sorry for the newbie question. Thanks in advance. :) Not the actual report viewer, but you could do that on your own, render the format in the appropiate format, Create a mail object, attach the rend ...Show All

• CesarDev10 Diagram, script and security ...

  Three things: 1 - I attached a database from another computer in the Microsoft SQL Server Management Studio Express tool. It looks like my database diagrams did not follow. At first, it told me that the owner of the database was not set correctly and, hence, diagrams could not be supported. I ran the following query to fix that -> Alter authorization on database::DB_NAME to [MACHINE_NAME\USER]. Now, I can create new diagrams but I would like to see the ones I had before. How can I transfer my database files (.mdf and .ldf) with the diagrams 2 – I would like to generate a database script that would not only create the table structure but also generate the insert statements to populate the database. When I use the ...Show All