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...
I'm trying to break this down into two parts. The first would be to make an intermediate table that has all the unique pairs. I guess an example...
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...
thank you. That was my issue. I was not using the correct join (I forgot how they actually worked). Thanks for reminding me, and for the help....
I tried that with the same results. Any other ideas? Thanks, Ben
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...
After doing some research, I think I know the issue, and that is that my replication replaces the delete sp with "NONE", and so when an update...
Thanks for the help. I have SP4, and i'm not using any identity columns. Is it true that if you try to insert twice on the production db (first one...
How do I find the service pack level? I've done it before, but can't remember the code. I feel like the instances are all up to date, but I will...
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...
I got this set up this weekend, and today am getting an error 8114. The schema was created new when i set it up, so i'm not sure why there could be...
Thanks for the quick reqly. Does Transactional Replication use a lot of resources on the production server? Do you have a good link for setting...
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,...
That makes sense. Thanks for the quick replies, Ben
The reason for the two procedures, is that the second one can be called individually, and does not rely on the first. the only thing that the first...
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...
Works great, thanks!
Separate names with a comma.
