Search results for query: *

I've been working on a problem that I can't quite figure out. I've tried different combinations of cross joins, CTEs, windowing functions, etc but could never quite get there. I'm also not wanting to go the dynamic SQL route. Can someone please help? Given a variable set of grouped values...

SQL Server 2008 R2 I have a 90 GB database running on RAID 10 with 8 spindles. I have 398 tables out of which 3 comprise 87% of all data. Here is the breakdown of percentage of total size: Table1 Clustered 24% Table1 NonClustered 22% Table2 Clustered 17% Table2 NonClustered 12% Table3...

SQL Server 2008 R2 I've got a stored procedure that was taking 30s to run. When I ran it in SSMS it would take under 100ms. The 1st thing I thought was parameter sniffing so I created local variables in the SP and assigned my params to them. That brought the time down to around 5s. I then...

Hi all, I have a table of operator events. OperatorID and EventTime are the important columns. What I want is to return all of the events but to identify groups of consecutive events by operator without cursors or looping. example (simplified): OperatorID EventTime 1 10:00 1...

I apologize if I confuse the terminology... I've got a proc that returns an aggregated value grouped by week and day like this Week Day Value 1 1 5 1 2 6 1 3 8 2 1 7 2 2 9 2 3 4 I've created a line chart with my limited...

I'm looking for some advice on whether or not SSAS is the right tool for the job. I work for an assembly line type manufacturer. We collect data at certain points in the manufacturing process at certain intervals. You can imagine the amount of data we're talking about when you're running 24/7...

I've seen requests on a few sites for an autocomplete solution for validation lists. Everyone here has helped me so much I thought I'd make a contribution attempt. I know this has it's shortcomings but it fulfills my current needs and should be able to be modified fairly easily for many...

I have a combobox that I move around on a worksheet based on which cell is selected. I have a named range that I use for the control's listfillrange. I update this range based on the value previously selected (the cell directly to the left of current selected). Here is the code I use to update...

I've got a combobox that dynamically updates it's selection list based on previous selections. I've got this working pretty good. The problem is that every time I refresh the querytable, the memory usage goes up. Eventually, this would become a big problem if not addressed. After some searching...

I'm looking for something that functions like ActiveWindow.ScrollColumn but that scrolls so that the selected column is the rightmost column in the window instead of the left. Any suggestions?

I use the following sub to move a combobox around, size it, and modify the range associated with the control. This is called on the worksheet's selection_change event to move and align the control to the selected cell. Public Sub MoveBox(Obj As OLEObject, aRange As Range) Dim c As Integer...

I created a class module with events to be able to create comboboxes at runtime. I create one combobox in A2 when the workbook is opened. Once a selection is made in that box, another is created in the cell directly below it. The problem comes in that the events on the newly created object will...

I'm pulling my hair out once again. Did I happen to mention my sincere admiration and respect for all of you out there. Ok, enough sucking up, onto the meat... I have a monthly build that runs a couple hundred stored procedures in sequence. This process takes approximately 15 hours to run. I...

I'm attempting to create an SSIS package that will import several excel files into a sindle table. I'm using openfiledialog in a script task to prompt user to select multiple excel files and then storing the array in an SSIS object variable. I'll then use foreach to process each file (have yet...

I've got the following code for multi-file selection: Dim localFiles() As String Dim localFile As String Dim listForEnumerator As ArrayList Dim OFD As New OpenFileDialog listForEnumerator = New ArrayList() Try With OFD...

So here's the deal. I just started with a new company as a SQL Developer/Analyst. I've got a couple years of experience with SQL Server, mostly 2000, on some fairly large and complex databases (or so I thought). So I get to this new company and the database structure is just wacky. I've never...