Search results for query: *

I thought I would try to help, even though I don't have the fancy screen shots and code blocks, etc. Drag and Drop an OLE DB Source onto a Dataflow. On the Connection Manager tab, create or use a connection to the database. The data access mode is SQL command. The SQL command text should return...

Cannot show visual studio for applications editor. The variable cannot be found. There seems to be many posts on this topic that even suggest uninstalling and reinstalling Visual Studio or other extreme ideas only to find out that after all the effort, the package still didn't work. I got this...

Thank you so much. I had a mental block on this. This is my actual SQL now that works. SELECT WorkstationID, Count(Product) InstallsCount From OfficeInstallations Where Product NOT IN ( 'Microsoft Office 2003 SP2', 'Microsoft Office Professional 2007 Trial', 'Microsoft Office Shared 64-bit...

I can't seem to get this simplest concept into SQL and work properly. All I want is to (pseudocode) SELECT WorkstationID Count(Product) From MyTable Where Count(Product > 1) AND Product NOT IN ('Product1','Product2', etc.) No matter what I write, I either get an error or I get the wrong results...

Thank you. And I didn't know there was a reporting services forum. Maybe you can answer this one question: Can I use the SQL statement from another report from another system as a dataset for my new SQL Server Report (as long as the syntax is correct? The reason I ask is that there is a place to...

I have some complicated SQL Statements with Case statements, grouping, etc in the SQL. I want to know how to create a dataset for this SQL. Then, I would like to know the best way to use that query in Reporting Services to create a report. Do I leave the grouping, having, order by in the query...

I am new to reporting services and have a database named MHC. I used this as a datasource for some reports. I am getting confused now as I used MHC as a dataset as well, and I have an idea of the difference, but not a complete understanding. Could someone explain this to me? Is a dataset really...

I have reports served to a report server and some pdf subscriptions sent to different places on a network. In the interest of lowering network traffic, I thought about exporting these reports to some kind of format that would be readable by an RSS reader and deploying them in an RSS Feed so each...

The simple answer is that the InOutID you're trying to insert into the table does not appear in the InOutStatus table." The funny thing is that it is in the InOutStatus table. Reading from the SQL Management Screen: dbo.InOutStatus (Columns): InOutID (PK, int, not null) InOut dbo.Transactions...

Thank you. I never ran the profiler before. I just started it but don't know what to look for. And is it possible to limit it to just the database you are using? Also, do you have any idea how I could fix the tables assuming that there is a problem with the constraints? Duane Wilson

Can anyone help me with this? The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Transactions.In_Out_Status". The conflict occurred in database "ComputerInventoryDCW", table "dbo.InOutStatus", column 'InOutID'. (#547) [Microsoft][SQL Native Client][SQL Server]. The statement...

I have created a pivot table successfully using the Excel object model from VBA in Access. I need 2 more copies of this pivot table on the SAME sheet with 2 different "pages" selected. So far, I have Dim xla as Excel.Application, xlw as Excel.Workbook, and xls as Excel.Worksheet and used these...

Thank you! That works perfectly. I must have had a mental block or something, but the second query wasn't even necessary; this reply just queries that second table directly, and works great. I am not sure why my initial query returned "Yes" for all the records - I still must be missing some...

I have this query that has a bunch of customers who have logged in or not. There are only 3 customers who have signed in, but when I make this query as a left join, it puts "YES" for Signed_In_Yet for every one on the left side (over 1000) even though the second query it's based on only returns...

Thank you for the reply. It is very clear. I didn't know about referencing a variable in frmA from frmB that way. It turns out I found a different way to solve the problem, but this will be here for next time. Duane Wilson

If I declare a module level variable (I think it's called that) on FormA and initialize it on the Load event, will it be visible to the after_update event on a combobox on SubformB or SubformC? I want to set this variable based on whether these fields have changed or not. I have 2 unbound...

Thank you. I think I have done that. Now, I must figure out why things that were working before this seemingly small change are not working now. For instance, I am now getting a 2455 Error (You entered an expression that has an invalid reference to the property |. The property may not exist or...

So, does that mean that if I dimension them in the top declarations, and then set them once somewhere in the code that they will retain that reference until it is changed somewhere else? Duane Wilson

I have several different controls on a form that refer to another form's combobox. I was setting it fresh in many different procedures and event procedures. I thought to, like private variables for the module to set them also once in the declaration section, and was able to Dim them, but I...

Will they stay set from sub to sub? Or will they need to be reset every time? Duane Wilson