as a next step in the product lifecycle is our service in a box which comes with a set of reports specific to that client.

we have a current user base...

something like this

create table #temp (id int, number int, value int)

insert into #temp (id, number, value) values (1,1,0),(2,1,1),(3,1,0),(4,2,0),(5,2,0)

with cte1 as

(

select

number

from

#temp

where

value > 0

group by

number

)

select

#temp.*

from

#temp

join

cte1

on

#temp.number = cte1.number

Thanks Basit, I'm diving deeper into this when I get a moment aside from the other things I'm working on.

One thing I would like to know is say I have...

the only gripe i have with SSIS is when you change the destination to a different column length or type as the meta data references the old type until you...

thanks, I think my little understanding of programming languages lets me down on this.

i've only ever had exposure to T-SQL as I'm a DBA, never been a developer so think...

BCP will work, get it to output the query into a flat file then upload the flat file to second server.

SSIS is very flexable, what do they mean by not...

can we see the agent alert system screen then and the operators details?

thanks thats the alerts and errors checking out fine, but can we see the rest, dont need to see email addresses etc so you can blank them out its more...

What is the reasoning behind not being able to use SSIS?

There are a couple of others like BCP and bulk insert what you could use, but I would challenge why...

can you attach screen shots of the alerts/operators/sql agent alert system/db mail accounts & profiles/errors in the error log so that we can invesitgate the configuration.

Is this for homework or interview by any chance?

Has this server sent mail before successfully? If not might be AV blocking mass mail worm or something blocking port 25 for SMTP or something along them lines

If it...

duplicate post

replies here please

please see this link

http://msdn.microsoft.com/en-us/library/ms143506%28SQL.105%29.aspx/

DBA at heart, but I do all things SQL related so development of DB objects and SSIS/RS/AS stuff as well as well as everything DBA