Search results for query: *

I have a database that will be used for replication. There are identity columns that will be auto managed on the publisher. During production, new bulk data is loaded into the database. (via SSIS) The data added from the WFE begins with an identity 100,000,000. The identity is managed by the...

So, I have this slow query... I try to keep the sps flexible, since we have so many (thousands) and business objects pass the same datasets around, so it's useful. Anyways.. I've found that there's a point where the query optimizer becomes retarded, its' around the 5 or 6 nullable parameter...

My brain isn't working this morning. I'm trying to figure out why when I'm catching errors I'm not able to see the actual SQL error through nested sps. ALTER PROCEDURE [dbo].[uspSitePermission_Insert] (@UserID as int ,@SiteID as int ,@HistoryID as int...

Anyone know how to do multi-group roll-ups? Example: Events Happen daily. Events Happen During Morning, Noon, Night People Do the events People Report to people. I have a drill down that shows: People reporting to people, the bottom person's events grouped and drilled to the day. I want...

Anyone know how to do multi-group roll-ups? Example: Events Happen daily. Events Happen During Morning, Noon, Night People Do the events People Report to people. I have a drill down that shows: People reporting to people, the bottom person's events grouped and drilled to the day. I want...

So.... I have a problem -- it's the same problem I have with KPI's. I created KPI's, but when I put them in SSRS to report them ALL members are associated with the KPI and it seems impossible to filter which members I want from a consumed parameter. So I changed it to a calculation -- this is...

Says there's an error near the 'for' i'm tired and I can't see the issue....... Select Date, StoreID, LaneID, DriveThruCarID, DriveOn, DriveOff, OrderNumber, OrderTotal, [OrderBoardDetector], [ServiceWindowDetector], [GreetDetector], [PaymentWindowDetector] FROM ( SELECT Date...

Salutations! I've been using SQL for a little while and I've been in a couple of shops, but I recently changed jobs and now at the new place everything on their SQL servers is case sensative. I can't figure out why (or how) they would do this. Is there a reason behind this? There's a...

The question is: Why would a recordset be EOF when the source SQL when queried has records. Immediate window: ?rst.Source Select path, file_name, missing, password from Files_To_Parse ?rst.EOF True Database query source for: Files_To_Parse SELECT Database.* FROM [Database] WHERE...

I have dream... I mean, I have a question. I sort of have this solved to a point, but not exactly. I have a table of dependancies. It looks like: [ID BIGINT] [Dependant_ID BIGINT] ID is the object, and Dependant ID is all the objects that the ID relies on. This can go in circles...

how do i name a relationship in the syntaxt CREATE TABLE ReportPeriod_ReportDate ( ReportPeriodID INTEGER NOT NULL, ReportDateID INTEGER NOT NULL, PRIMARY KEY(ReportPeriodID, ReportDateID), FOREIGN KEY(ReportPeriodID) REFERENCES ReportPeriod(ReportPeriodID) ON DELETE NO...

What object type is it that Access uses in it's main window? On the left it has "objects", "groups", "favorites" for nagivating. What type of menu object is this? Just curious. I'd like to use it -- never really saw the need, since moving to .NET, but now that I'm using VB 6 Again I want to...

I write this, and it works. It pulls the column names along with the Primary Key where rows have a null in the given column. example out put: Loan_Num, NullColumnName 123123 LN_Setup_date 123121 LN_Setup_Date 123121 CR_IND_SW ............... also outputs in another format when I...

So.... I left some loose strings in an installer, I didn't finish an installer and someone ran the MSI before it was 'completed'. Now when they run the newest version it doesn't allow them to uninstall the previous version (even though I have it marked to allow removal of previous versions)...

I have the error: This is the line that creates it: jro.CompactDatabase(strSource, strDest) in the context of: Public Sub CompactFile(ByVal DBFileName As String) Dim jro As JRO.JetEngine jro = New JRO.JetEngine Dim tempDBFileName As String...

I don't know why this doesn't work... I'm getting the error: "ODBC--Connection to '{SQL Server}ServerName' Failed" I'm trying to add tables to a MSACCESS2k3 database from a remote server, Using ODBC without mapping System DSNs. Any help is appreciated. Public Function...

is there a way to pass a parameter to class at initialization? eg... Private Sub Class_Initialize(objClassData As clsBuildCode) Set objBuildForm.adtClassData = objClassData End Sub I can't seem to pass data at intialization, how does VBA do this? Randall Vollen Merrill Lynch

I'm trying to find the User name of someone that has a file opened on the network drive programatically, I've been able to fetch their Computer name, but not their user name. If I have the username I can fetch their full name from Private Declare Function apiNetUserGetInfo _ Lib...

I have the following: select top 1 Loan_Num, Due_date = (Select due_date from dbo.fnc_FetchSingleLoanInfo(Loan_num, add_date)) from tblComments order by Add_date desc Where definition of fnc_FetchSingleLoanInfo: ALTER Function dbo.fnc_FetchSingleLoanInfo ( @charLoanNum as char(10)...

Assuming that the Schema of my database is normalized and complete.. I would like to be able to do the following: query sysobjects or a sysview that when given the name of 2 tables would return all tables between the two tables via relationships. (I only want tables that are between the two...