Search results for query: *

Hi, I have reviewed a few articles on locking data (record locks, table locks, etc) and on constraints, which appear easier. I am looking for guidance on which level locking I should use in a SQL Server 2005 db and how best to apply constraints to a table. I am developing a staffing profile...

Hi, I am attempting to develop a data warehouse for project management finance, forecast and budget reporting in SQL Server 2005. All I have is SSMS and SSIS BI ETL and I won't be able to get anything else. I have 4 fact tables and the following are descriptive names for this post...

Hi, I have a stored procedure in SQL 2005 that creates a table at the beginning of the SP, inserts into the newly created table and then from that newly created table I insert into a Fact table joining with all of the Dimension tables to create my foreign keys in the fact table. The reason I...

Hi, I understand that a unique clusterd index is required on a view before adding nonclustered indexes. The problem I am having is that I bring through a primary key identifier field (unique field values only) from the FactTable (Table: FactActuals, Field: ActualsID). I thought I could crete a...

Hi, I have an ETL package that performs the following steps: 1) Truncates the Import table where I import the file 2) Calls a stored procedure function to get the name of the txt file I am going to import (the name of the file is a date). The function populates a string variable, which takes...

Hi, I have been searching for weeks on attempting to find the best practices for running a process that was orignally developed in MS Access, that I had to deconstruct the entire database, implement a Star Schema, and then replace the processing portion. Essentially, what I did was break-up all...

Techinically, I work in the IT department, but I am in the Financial Operations side which has a lot more business people than IT people. I was wondering if someone who were granted rights to the sql server db would be able to initiate an SSIS ETL package without having any sql server 2005...

Techinically, I work in the IT department, but I am in the Financial Operations side which has a lot more business people than IT people. I was wondering if someone who were granted rights to the sql server db would be able to initiate an SSIS ETL package without having any sql server 2005...

Hi, I am trying to write a stored procedure that has an input parameter. That input parameter will determine which INSERT script I want to run in the stored procedure. The problem I am having is I can't seem to figure out how to wrap the Insert Statements in the Case statements without getting...

Hi, I am developing a SQL Server 2005 reporting database. I will have a reporting template as a UI in Excel 2003 that will call stored procedures to populate the Excel reports. I've done that in the past and it is easy. I will also have a data entry template (UI) that users will use to insert...

Hi, I am trying, after my package runs succesfully, to have a simple SQL statement run (summarizing two fields from my import table) and have the results be place in a message box so the user sees the two fields summarized in the message box so they can confirm against a Cognos application that...

Hi, (the following stored procedure can be placed in anyones query window and run b.c it does not have any relation to any tables. Only functions in 2005) What I am trying to do is create a stored procedure that will take the value of the GetDate() function (Current Date) and manipulate the...

I don't see my thread out there so I am posting again. Strange... Hi, I am relatively new to SSIS 2005 and I am looking to add to my current package two things. First, I guess I should explain what my package does now. 1) I have an Execute SQL Task that truncates the table I am inserting...

Hi, I am currently running a database from another database. Everything works fine, but I am trying to put in a precautionary step. I have a form from the 1st database that imports a .csv file into another database. The only "problem" I am having with my precautionary step is that when I...

Hi, I am currently running a database from another database. Everything works fine, but I am trying to put in a precautionary step. I have a form from the 1st database that imports a .csv file into another database. The only "problem" I am having with my precautionary step is that when I...

Hi, I am trying to select multiple selections from a list box from a user form. The list consists of various sheet names. I have set the list box up for multiple selections and I am trying to print all of the sheets that were selected from this form. Here is the code I have been working on...

Hi, I have a table that has several fields, but for the action I want to perform there are only 2 fields of concern, Field1 and Field2. Field1 is string and contains material designation id's (MCP) and Field2 contains the quantity of the material (Quantity1). What I want to do is delete all...

Hi All, I am trying to compare records in an Access table using VBA and I really want to do this in VBA. Please don't respond if you are going to suggest running various queries, etc., through the query "wizard". For example, I have a table with two important fields, say Field1 (string) and...

Hello, I want to delete the correct records in Access based on a date by performing a calculation. This is an example of the data: MCP QUANTITY DOC DATE 4036311/665940/3100 1 5/23/2005 4036311/665940/3100 1 5/18/2005 4036311/665940/3100 -1 5/23/2005...