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

Assuming that they are both still changing and that these changes need to be reflected in the reporting server, I would keep them separate.

Consider using replication to keep the DBs...

A bit off topic, but why are you casting the dates as varchars?

SQL.AP (11/10/2015)

---

There are various interfaces which are independent, so they would be executed in parallel. However, we've a changing req. and in future there would be more interfaces coming and...

system243trd (11/9/2015)

---

I have created a package that will insert new rows into destination1 if the AnID does not exist in Source1. This uses a data flow task which contains...

aikman2222 (11/10/2015)

---

Hi Phil,

I have two columns in my source data, Created and Change that I want to check against.

I have succed it with a Stored Procedure:

where

cast(o.created as date) >=...

aikman2222 (11/10/2015)

---

Hi,

Am a newbie in SSIS and need help with following:

Have a load and the last step in the Control Flow I update LastImportDate in a Table

update ParamSettings set

value...