Hello, I'm trying to figure out how best way to group records that are consecutive. For example, I take service calls for my company, and I put an...
Hello, I run 3 queries. The first get's everything from a table, the second get's everything from that table that isn't in another table, and the...
Hello, I have a table that has an ID, customer, Date, OrderNum, and partSKU. I would like to report on how many times sku "x" is in the same order as...
Hello, I'm having trouble figuring out what's going on here. If I try to do a select with an outer join on my table, i get 3 million rows back. If...
I'm getting this error on the distributor for my replication. It says succeeded, but than says this and won't update the replicated data. I had a...
I'm trying to figure out why I'm getting this error. I used my program to insert a record into my production db. That worked fine. The...
Hello, I have an archive database that we use for reporting and archiving data for up to 14 months. Currently, I use a C++ program to update this...
How do I use the calculated field (SumQuantity) below in my where clause? I'm getting error: invalid column name SumQuantity. Thank you in advance,...
Hello, I have a SP that calls a second SP. They both use cursors, and the purpose is to scan through a table (classSKUInv) and update each row with...
I imagine this is less efficient than putting the information into a list or something. All 4 columns that are being updated come from the same...
Hello, Here is a query I have. I'd like to use the result set to update each recdoc with a count of cartons associated to that recdoc that is on...
I'm doing an engineering study for a customer of ours. The data they gave us is pretty confusing. right now i'm trying to find the count of each...
Is there a way to get the value of a column that is not part of the group by clause? I have a query: SELECT pkt_dtl.SKU_ID, Count(*) AS Occurrences...
We have a table that is getting written to by a third party app. It is a varchar(<img src='/community/emoticons/emotion-11.gif' alt='8)' /> and is...
I have a table that has sku and quantity (along with pick number, but I am not showing that. it is the primary key). There are multiple rows with...
Hello, I have a query that I run to copy data every half hour from my production db to my archive db. That query will get 1000's of rows. I just...
Is there a way to have a query continue processing after a fk violation. For example, I have a query that select a bunch of rows, and posts them to...
I'm trying to use the DTS export functionality with a script to transfer data from one db to another. The issue i'm having is that I don't have just...
Hello, I'm implementing a system that needs to be online all the time. This is an addition to a system we implemented several years ago. At that...
I have a system that has two databases. One is for reporting/archiving and the other is for production. The production one needs to stay lean with...
Separate names with a comma.
