Also, if lots of data is involved, that WHERE clause is going to tax the database engine because of all those function calls. We may be able to help optimise...

cstrati (9/5/2014)

---

I have a view I've created which displays client sortname, partner and date added which displays 7 results.

When I add another table to this view to display the Industry...

mark 66658 (9/3/2014)

---

Hi, thanks for the article on DataVault and BIML! I'd very much like to see a series of articles on the topic if at all possible. ...

I also like the derived column idea.

Replace ')' with '' (empty string).

Replace '(' with '-' (minus)

+1

ronan.healy (8/27/2014)

---

this is a sample from a column BNY Mellon - 07/01/2014

so all the columns will always have that date format and I want to text the text after the...

So you want to trim from a certain point, and that point varies from one string to the next? Tough.

Can you describe the requirement more clearly please? Some examples would...

Left(Col1,[Number of chars to keep])

AarionSSQL (8/25/2014)

---

Hi All,

Could you tell me how to add database objects to BIDS Projects.

I am working on SSIS and have seen a project where the database object definitions such...

Mr.Sahand (8/25/2014)

---

Thanks Phil for the answer.

The rules are not too complicated to be done through T-SQL or Access query or VB scripting.

Although they are many in number. They are...

Mr.Sahand (8/25/2014)

---

I am new to SSIS.:-D

I have a number of MS access tables to transform to SQL. Some of these tables have datetime fields needed to go under some rather...

brad.mccollum (8/23/2014)

---

I have an SSIS package that basically does ETL on an Excel file then outputs everything into a new Excel file.

As an example, let's say my original Excel...

You can STUFF it!

DECLARE @Val1 varchar(5) = '12345'

declare @RetVal varchar(10)

set @RetVal = STUFF(@Val1,3,1,'A')

select @Val1

, @RetVal

rajeshjaiswalraj (8/23/2014)

---

I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE...

Yes. And suddenly, yours is...