mamtap (2/15/2008)

---

I have the same error but my problem is that I set the AttributeHierarchyDisplayFolder to "\" which I need it for excel. Is there any escape characters that can...

As far as a NON-sysAdmin who has CREATE, ALTER, DROP, etc., take a look at the DDL_Admin database role in BOL.

Hey guys. Not to jump to conclusions here, but it seems to me that we are trying to address presentation issues at the data layer. In most cases,...

You stated that “the line items may not be stored right after one another”. Is there at least some sore of key value that relates the 2 lines? ...

How are the results being displayed to the user? Webform, VB App, Crystal Report, etc?

You are correct; you cannot deny access at the database level.  As per Mike's previous suggestion, what we need to do is GRANT access at...

What are the datatypes of your starttime, releasetime, & endtime columns in your intermediate target table?

 

Sorry that I don’t have time to fully research this right now, but there has to be an easier way of doing this (through querying a combo of system tables...

Is the VB app conducting its work through Stored Procs or are you allowing for ad-hoc SQL to be run against the database?

Using either a WHILE LOOP or CURSOR...

build your list of unique EmployeeIDs.

Looping/Cursoring through your list of EmployeeIDs, Updating value of @EmployeeID and @MyExcelFileName

bcp " SELECT    

Sales.Quarter02.[ProjectName ],

Sales.Quarter02.[ReportNo ],

Sales.Quarter02.[Valuation ],...

How is the DTS data pull being executed?  Is it a SQL job that is scheduled?  Is someone running it from EM DTS Designer, DTS...

also, you may want to create a "Months" TABLE containing MonthId, MonthName and join to it.  You could replace your mutli-CASE statement w/ a simple SELECT MonthName.

make sure that if you are going to use smalldatetime that all of your dates are between "January 1, 1900, through June 6, 2079"

see "sp_change_users_login" in BOL.

How often is the third party Data Cube getting refreshed?