Is this what you are looking for?

create table dbo.BillTest (

TypeID char(3),

Code ...

I love Chipolte, too bad there isn't one out here in Afghanistan. I got to finish my lunch.

Just a guess, but I would think as long as you have the certificate used to encrypt the database with TDE it should not matter what backup software you use,...

Problem I see is the DROP EXISTING in the create index statement. If the index exists you drop it. For the DROP EXISTING to work the index must...

marcossuriel (3/22/2014)

---

Hello Everyone,

Thank you for reading my post. I think I'm half way from where I need to be with this query below. My end goal is to be...

Modified the order by so that it listed output in descending order by RepairsOfThisTire by DealerId, which what you original indicated what you also wanted.

CREATE TABLE dbo.Table1 (DealerId INT,...

Added another dealer with 10 orders, 9 for one timre and 1 for a different tire. The new dealer shows up, but again the count of the Repairs for...

Added two more orders for the same tire and Dealer 3 shows up but only reports the tire as 66% of the total when in actuality it is 100%.

CREATE TABLE...

Curious, is this what you actually want? I added a third dealer with only one order for one tire. This dealer does not show up in the results...

Just an FYI, you shouldn't order by ordinal values. You really should specify the column names you are ordering by. If I remember correctly ordering by ordinal values...

Don't have an answer to your question, but I have a question that may help. How would you capture deletes from the source table? CDC should capture this...

Here is how I would do it. First of all, since you appear to be running SQL Server 2008, I would not use sysobjects.

declare @SQLCmd nvarchar(max);

select @SQLCmd = stuff((select...

Here is my shot at what you were trying to accomplish. The only difference between my final output and yours is that I left off the ID as it...

Glad you got an answer because I still haven't figured out what it is you are actually trying to accomplish.

malcolm.garbett (3/20/2014)

---

Thanks Lynn,

Value 1 = 10

Value 2 = -12

Can they be summed to produce...