Methew (2/7/2013)

---

i have a table with three fields

id,bank_id,amount

it has alot of data....how i can select last entry for all distinct banks ?

lets say(Below code has not tested)

IF OBJECT_ID('TempDB..#mytable1','U') IS NOT...

You could add another level of nesting:

Expression < 0 ? 0 : Expression

where expression is the entire statement you currently have.

Or - slightly unorthodox - add another derived column transformation...

Great, no problem!

Here's one way, I think

update it

set Add1 = s.Add1

,Add2 = s.Add2

from dbo.items_test it

join dbo.Staging1 s on it.Location = s.Location

and it.ProdCode = s.ProdCode

and it.Customer = s.Customer

where it.Date_Effective =...

Jason-299789 (2/6/2013)

---

Phil,

It was aimed as more of an example of how to generate the basic data (ie a Sequential date), so that you can then start adding on the...

wafw1971 (2/6/2013)

---

thanks for the quick replies, because I am learning I have decided to just populate the first column with a date say 01/01/2010 and then increase this in increments...

Jason-299789 (2/6/2013)

---

(reposted from other thread)

Your best bet is to use a TALLY table, a CTE, or at worst a Recursive CTE.

using an crude tally table

With Cte_n

AS

(

Select 1 a Union...

aaron.reese (2/6/2013)

---

Resolved but not happy:angry:

from the command line I have to use the /conf[iguration] switch to specify the location of the config file which will then override the location specified...

fecker (2/6/2013)

---

First: thanks for your feedback. Description may be strange while I am german.

I did some screenshots (attached) - for this dummy - maybe this will explain more. I run

this...

iamsql1 (2/5/2013)

---

HI

i have a qs: if i have a data flow task inside for loop container. and DFT contains five static connections of FLAt file as Source...

The SQL Agent job runs asynchronously - so it's not going to return 'finished' info to your application.

You could, perhaps, implement an MSMQ solution, though that may be a sledgehammer...

I tried understanding what you are trying to do, but it confused me as it's not written very clearly.

But then you have said that your script task to update a...

opc.three (2/5/2013)

---

The issue is that...

aaron.reese (2/4/2013)

---

Thanks Phil, That was a useful lesson.

Unfortunately I can't see how to assign the value to a variable without using a script. I have tried sending the...

Read the file in a dataflow.

Add a conditional split which redirects processing according to what has been read - two outputs: Build Success and the rest.

Each different path sets a...