So of those products in those stores, how would i see my sales broken down by store by product if its not coming from the cube...write group by SQL statements?...

LightVader (4/21/2011)

---

Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only...

thanks bb...someone else had posted this which works quite well

; with

combined_table

as

(

selectCustNum, Event_Date, plan_code, type,

rowno = dense_rank() over (partition by CustNum, Event_Date order by plan_code)

from

(

select CustNum, Event_Date, plan_code = Before_plan,...

Sorry guys!

Here goes:

create table #table2

(

CustomerNum int,

...

berry, no your assumption is wrong

table1 doesnt have 3 fixed offer names..it can have N offers..

my source table is table1

my dest table is table2

its complicated because i only start with...

Thanks Paul but if you look at what i am trying to do here, Pivoting is the easy part. How to relate the records is what i am having difficulty...

I agree with a lot of users here that Powershell and SMO are much much better choices.

Mike.Renwick..i will look into your Powershell code...its a great start.

Jon Mcghee...is it possible...

Hi All,

Thanks for the replies however the 2 solutions above do not work. The Row_Number solution was giving me incorrect output and the second solution just by looking at it...

oh that was easy 🙂

Thanks for the tip!

Btw...the code is formatted...i am still new around here...i guess i need to learn how to enclose code so its formatted in here 🙂

SELECT col1 FROM tbl1

--test

Its nothing complicated, simply a previous developer left code which i am converting to a stored proc. it has 2 parts and not all fields can be present during the...

Jeff...this is pretty close...however this keeps the lowest row ID of any duplicates found and deletes the higher row IDs..i need it the other way around..

i tried row ID desc...

Hmmm Jeff..thanks for the input...

i am surprised by the results with your code...i am wondering why...because it works perfectly with the same data i posted above

sorry for the late reply guys

berry...this worked perfect..i cant believe how simple this is...

if anyone is interested, here's the sample script

create table sample_7day (call_id int identity(1,1), UserID int, Post_date datetime)

insert...

just looking at your error, its picking up a space which will NOT convert to an int type.