Something more like this maybe:

use SandBox; -- Move to a SandBox database for testing

go

create table dbo.ConversionsTest (

ActDate date,

AdId int,

...

Jack Corbett (4/26/2013)

---

Grant Fritchey (4/26/2013)

---

jasona.work (4/26/2013)

---

I just going to hope we don't get mocked on Saturday for wearing our Red Wings jerseys...

As for smuggling back Canucks, do we...

jdbrown239 (4/26/2013)

---

Lynn

You guys were right about the 'Where' clause being the issue. I added a few indexes to the table to increase performance and went back to a suggested 'where'...

I'm not going to ask you for the DDL for the tables, or sample data, or expected results. I would like to see and ERD with the tables (including...

If a phone number can only belong to one entity, why are you trying to make it a many to many relationship?

Here is one of your queries reformatted to make it more readable. I am concerned about the WHERE clause. You are using both AND and OR in the...

Read the blog post that Grant provided you a link to above.

Your t-log is growing...

Start with your original post and the three sample records you provided. Does this recurse forever?

What is your expected results based on those three sample records?

DKN2101 (4/24/2013)

---

Syntax error.

If i do:

SELECT MAX(Revenue_Spend) AS "Largest Amount Spent" FROM MaxCents

I get the max amount spent, but I can't figure out how to get it to display...

Sqlism (4/25/2013)

---

declare @min-2 numeric(18,0)

declare @max-2 numeric(18,0)

declare @parts numeric(18,0)

select @min-2 = 102201011472463 ,

@max-2 = 102201354392808,

@parts = 3480

declare @increment int = (@max - @min-2) / @parts while @max-2 >= @min-2

begin...

I think mine is very similar to Sean's:

declare @Parts int = 5,

@InitialValue bigint = 5000000000000480,

...

No, I agree that he was telling you...

Me thinks the wrong person was told to take a chill pill. I...

Abu Dina (4/25/2013)

---

Some weeks ago I had this issue. I used table variables to solve a problem. They were great until requirements changed and the code had to be adapted...

If you are crossing databases the user needs access to the table(s) in the other databases.