As a follow-up example.

I have a table, call it tableA, that contains 1 million rows on my publisher and uses 103 MEGs of data space.

tableA in the subscriber database...

like this maybe?

SELECT

EMPL_ID,

PAY_TYPE_ID,

SUM(LABOR_HRS) AS 'HOURS',

SUM((case when pay_type_id = 99 then 0 else LABOR_COST end)) AS 'Labor Cost'

Lynn Pettis (3/19/2013)

Full and Differential backups do not truncate...

Unless I'm misunderstanding what you want it sounds like you want to use a left join..

Something like..

select t1.concatenate, t2.concatenate

from table1 t1

left join table2 t2

on t1.concatenate = t2.concatenate

Maybe? You're trying...

Why are you shrinking the log file? If your backup method is Full then the logfile will truncate on backup.

What about taking the row_number out of vw_BatchItems completely and putting row_number() over (order by DateEntered) in the usp_sel_BatchItems view?

with much information I had to make some guesses.. something like this?

CREATE TABLE #temp

(

id INT,...

Something like this maybe?

DECLARE @factorial VARCHAR(255)

SET @factorial = ''

CREATE TABLE #temp

(

id INT,

...

I think you could possible have posted this in the wrong section but I hope this helps you.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/278e691c-45ac-4c92-9193-67999e4be7fd

Ah.. that makes sense. Thank you very much.

Hmm did I put this in the wrong section?

Yeah, I've tried that before to no luck. Any T-SQL inside the switches are all evaluated BEFORE the switches and they'll fail if the version isn't correct. You might have...

Are you using a server group or linked servers?

Can you share the DDL for the tables and some sample data?

I don't suppose you're going to make it easy on use and mention that all the skus are comprised of numbers, right?

If they are all numbers you can use something...