Use the RIGHT() function.

Right('0' + col,2)

If you take the time to post the data in consumable form (see the link in my signature), I will show you how.

A correlated subquery is not required in this...

Nice one Scott. Must remember that trick.

Hopefully your framework allows you to set the max concurrent number of executing packages per job.

I'd suggest playing with that number a bit. Start on the low side and gradually...

That very process was recently described in this thread.

Also, literal dates are best written in 'YYYYMMDD' format, eg, '20791201', to avoid any possible DMY, MDY confusion.

ChrisM@Work (11/12/2015)

---

Ed Wagner (11/12/2015)

---

Sean Lange (11/12/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function,...

nexus2vijay (11/12/2015)

---

Thanks for the revert Bossman.

I'm not a Techie infact. I'm from Teaching field and new to IT industry and getting to know the DB.

If you could help me out...

nexus2vijay (11/12/2015)

---

Hi,

From the attached 4 Tables Schema Diagram

Will the below query Reduce me the ListPrice by 20% if i didn't receive the order for the last 2 years ? Jammed...

OK, version 2.

declare @x varchar(500) = '&StartRow=1&EndRow=1000&LoginID=40&ProjectAssessment=16&ShowColumns=Asset&ShowColumns=Category&ShowColumns=IOL&ShowColumns=Vulnerability%20Exposed&AssetDescription=&';

select @x

,left(replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12), '&ShowColumns=', ','),charindex('&',replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12), '&ShowColumns=', ','))-1)

robert.wiglesworth (11/12/2015)

---

I am working with a table that does not work for me. I want to create a new table with a different structure. Here is an example of how...

You could try this. Might not work in all circumstances though:

declare @x varchar(500) = '&StartRow=1&EndRow=1000&LoginID=40&ProjectAssessment=16&ShowColumns=Asset&ShowColumns=Category&ShowColumns=IOL&ShowColumns=Vulnerability%20Exposed&AssetDescription=&';

select @x

,replace(replace(right(@x, len(@x) - charindex('&ShowColumns=', @x) - 12),...

nexus2vijay (11/12/2015)

---

Hi Friends,

Attached the Schema of a DB with 4 Tables.

1.Query to get the customers with the total sales, who placed an order last year but not this year.

•Column...

If the solution you are considering is as simple as you suggest, there is little point in staging anything. Instead

1) Dataflow task with source Server1.Source1

2) Data source to fully-cached Lookup...

Sure.

Let's assume your source proc is called dbo.proc and it has a parameter called @MaxDate.

Point your OLEDB data source at your source database and in SQL commend text, enter:

exec dbo.Proc...