If you really need to do this, you might have to resort to dynamic SQL. At the moment, SQL is treating 'USA','CAN' as a single-valued list (so if the country...

Roland, I tweaked your query a little to include a WHERE clause & was consequently able to simplify the CASE construct. Also, your update needed to reference the alias (t1)...

Why? Why not a subordinate of someone else?

There is no ordering of data and there is no way for SQL...

popq79 34287 (12/31/2012)

---

OrderID is auto gen number but can use orderdate for this purpose.

If there is one order placed, then I want both min/max to contain the same long with...

Does the OrderId column follow an ascending pattern? What I mean is, can we assume that, for each customer,

Min(OrderId) is the first order

and

Max(OrderId) is the most recent order

?

Also, if a...

axwack (12/26/2012)

---

I have a spreadsheet that culls the data from the sheet and inserts these into parameters in stored procedures. If there is an error on the sheet or the...

Saravanan, can you answer Dave Ballantyne's question? It is a critical point.

ngreene (12/28/2012)

---

(DT_STR,50,1252)(band == "C1" ? "Developer" : band == "C2" ? "Tech Lead" : "Something Else")

I added the string conversion "(DT_STR,50,1252)" incase you are inserting into a varchar field. ...

Jon Jaroska (12/28/2012)

---

The package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:

There...

krishnasrisatya (12/28/2012)

---

I want to give conditional statement in dervied column by adding a new column.In band column if Band is B1 then in new column it should be Manager like...

Jon Jaroska (12/26/2012)

---

I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there...

There are others - simply setting a pre-execute breakpoint on...

My solution handles that.

Here's my pseudo-code expanded a bit to accommodate the start and end date bits:

declare @StartDate datetime

,@EndDate datetime

set @EndDate = dateadd(hour, 8, DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(HOUR, - 8, getdate()))))

set @StartDate...

Phil Parkin (12/27/2012)

---

asita (12/26/2012)

---

Hello All,

Could you please help me out here, i am totally stuck here,

i have total 20 tasks in my ssis package (dataflow, execute sql task, etc)

at 16...