Search results for query: *

Hi, I might be a little late but I would try copying range("A1:AF1"), e.g., Range("A1:AF1").Copy, or [A1:AF1].Copy. Personally, I don't use the brackets b.c I was running an app the other day that I had used with brackets and the cod just stopped on a line that only had brackets and copy, or...

Thanks for the reply. I hope you or someone else can provide further assistance. I am going to easily have to manage 2 thousand to 3 thousand employees. It doesn't seem practical to have 2k to 3k tables related to individual employees. Granted, each table would be small, but wouldn't I be...

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...

Genomon, thanks for the post. I did place the Create table in the transaction handling portion. I must've forgot it was there when I was redoing my stored procs for transactions.

Found the answer. "SET ANSI_PADDING OFF" When I comment that out the sp works b.c there are schema bound views that pull all of the true data values back together for quering and I have a unique index and nonclustered indexes on my views. I believe the ANSI PADDING OFF was affecting the...

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...

Wow. Good to know. Thanks for posting. Based on the information given I would've guessed the users had a bunch of apps running while they were running the xls.

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...

Thanks, Emtucifor, I think once I have time to upgrade the process I will use what you have posted. Thank you again. Paul

Thanks again. I will definitely take what you have said into consideration. If the ETL packages were more complex, what you state would be a huge issue with what I am doing. If you have time and there is anything else you can think of, I appreciate the comments. Paul

Hi, RiverGuy. Thanks for the reply. I need this entire transaction to fail b.c it will be initiated by an ETL package and any errors that arrise in the process, I want the entire transaction to fail and have everything rolled back. I do have the granularity you suggest as each SP that is...

Markros, I would have considerably more stored procedures as I am trying to get unique values inserted into the dimension tables in the star schema db structure where this SP resides. So there are roughly 30 Dimension tables and I don't want to create 30 separate stored procedures, and maintain...

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...

Emtucifor, Here is what I have done after reading gmmastros link to dynamic sql and using sp_executesql, basically following the QuoteName() rule and the dbo rule. I no longer use the EXEC to execture the @sql line. Here is my code: DECLARE @sql nvarchar(Max), @params nvarchar(Max)...

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...

I just made another post and saw everyone posting re: dynamic SQL. I am going to read the links you guys posted and thanks for taking the time to reply. Much appreciated. Also, I did use the dynamic sql in my stored proc and I parameterized all field names and concatenated all in the...

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...

Nevermind, Jeff, I am reading up on it now. I have a vb programming backroung and I understand what is needed to be done. Pretty cool stuff. Thanks, Paul