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

...could have 10k to 40k records (all employees, offshore, etc.). Each employee can be assigned to multiple projects as far out as 2 years, so 24 * each employee. As you can imagine, two or more project managers at one time could access one employee and try to allocate that employee to a...

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

...Below is the Stored Proc. I do not believe any of the issues deal the Transaction processing. Any help is appreciated. USE [FinancialDB] GO /****** Object: StoredProcedure [dbo].[uspTimeDetailInsertExtractCognos] Script Date: 10/22/2009 14:14:57 ******/ SET ANSI_NULLS ON GO SET...

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.

...back together in the view? I also have schemabinding referenced. Here is my view and any help would be appreciated. USE [FinancialDB] GO /****** Object: View [dbo].[ActualsProgramFiles] Script Date: 10/16/2009 12:47:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...

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

...dynamic sql...lol, which I did change to the sp_executesql with QuoteName and dbo safeties) I would greatly appreciate it: USE [FinancialDB] GO /****** Object: StoredProcedure [dbo].[uspTimeDetailProcess] Script Date: 10/13/2009 10:56:47 ******/ SET ANSI_NULLS ON GO SET...

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