Search results for query: *

I've sucessfully passed string parameters back to a stored procedure to limit data coming into my report, but now have to pass a list of integers to a report to filter on. My report is failing saying it's unable to convert a string to an integer. I guess that SSRS passes all such back to an sp...

I've created a new smartlist and set the security to allow it to be seen by specific user classes, but they cannot see it. Once I log out of Dynamics and back in, it disappears from my smartlist as well. Any ideas? Dynamics 9.0 on SQL2005. Thanks!

I am trying (so far unsucessfully) to use the @@error function to trap errors, record them and send the result set to me via email so I can "correct" the bad data in the specific rows. declare @error int set @error =0 BEGIN TRANSACTION insert into request_event select externalrefid...

Let me preface this request for help with the disclaimer that @@error is somewhat of a mystery to me. I understand somewhat what it does, but using this function has proven to be tricky. BEGIN TRANSACTION insert into request_event select externalrefid, sequence, security_code...

We just purchased and installed the field service module in Dynamics 9.0. Our current call handling software has similar features, but not exactly the same and not as in-depth as Dynamics goes, so pulling that over to Dynamics is not going to be as simple as a=b. That being said, have any of...

I'm trying to set user security in 9.0 using Advanced Security. I've created several classes some of which don't need access to anything on the financials side. When I deselect financial under the menu options, the program gives me warnings of dire consequences for doing this. I've looked...

I have a DTS job that reads through a set of files in a folder, extracts the data in the files into a table in my database. Until I have everything working smoothly, I don't want to delete those files, but want to move them into another folder. Can anyone point me somewhere that might have...

When running the following code, I get an error "Microsoft Data Transformation Services (DTS) Package connection ('Text File(Source)')was not found. I do have a text source connection defined in the package. What did I do wrong? Here is my code Function Main() Const...

I have a web page that has links to various PDF files on the page. The PDF files live on the same server with the web page, but unless the user is inside the network, the files will not come up. If it would at least ask for a login and password, I could handle this as the files are really only...

I have created a DTS job to import a text file to my server. The file is named based on the date and time it was put in the folder and I've done a dynamic job to cycle through the names to upload all the files. My question revolves around marking the file as uplodaded once they are done...

We recently began using our inventory management module in Dynamics version 8.0. In order to load our inventory (which existed in another database), we did a table import function which pulled in all stock on-hands for each location and part number. Some of our locations had negative...

I'm trying to create a floating division within my page that has a background image in it. I've got coding in the css page that goes like: div.txt{ position:absolute; top:250px; left:175px; height:400px; width:70%; font-family:Bacon, Arial; font-size:14pt; color:#4d4f33...

I'm getting the following error on my backup jobs. The device is not off-line and the file exists. A bit of history -- we replaced one Raid 5 disc array with a newer, larger one. MSDB, Master, TEMPDB and Model were all on the array that was not replaced. Only user databases were on the...

SQL 2000 with Windows 2000 OS and we are going to install new drives on it as we are running out of space. My question is --which is the best method; to remove the old drives and restore the databases on them from a backup or detach and move the databases to a holding drive while the new drive...

I've created an excel query to my SQL database to pull in some tabular data for reporting. I want to make this available to web users who log in to the website, but while the spreadsheet comes up just fine, when the query tries to execute, I get a "cannot find SQL server" error. If I'm in...

I think I'm missing something somewhere. I'm trying to create a parameter query where a person will enter his/her id number and the query will pull only pertinent data to that id in the form of a pivot table. When I follow the instructions on Microsoft's help and website, my query tells me that...

I'm trying to concatenate some nullable columns into one column. Am using coalesce, but it's not returning the expected values. Can someone take a look at this code and advise me where I've gone wrong? update msn_newCall set notify = COALESCE( NULLIF ( arc, '') + ';' + NULLIF (billto, '') +...

I have a DTS job that is pulling in information from EXCEL into a table I created in my SQL 7.0 database. When I first created the job, it worked fine. The owners of the EXCEL spreadsheet have made some changes to it and when I adjusted the job to accomodate those changes I now get this error...

I'm trying to reindex/reogranize my indexes to improve performance on the database and have a couple of questions regarding the options for setting indexes. Example 1: I have a very small table that very seldom gets anything inserted in it (like maybe once a year if we reorganize the...

I have a small table with 18 columns and 602 rows. It has two indexes on it; one clustered on the primary key and the other non-clustered index includes the primary key and a column that is the primary key in a table that is used in conjunction with this one to apply pricing levels to customers...