opc.three (2/6/2013)

---

J M-314995 (2/6/2013)

---

If there is a way to import files using a wildcard character without having to rename the files (using a static file name), I'd sure like to...

Thanks for posting back - glad to help.

OK, I fixed up your sample data to use a proper IDENTITY PK and not to try and insert varchars into the INT bank_id column. Solution below:

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

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...