DECLARE @column varchar(50) = 'user1@email.com';

SELECT LEFT(@column, CHARINDEX('@', @column, 1) -1);

Short

Vino

-- Updating a single-table CTE updates the underlying table, so the change is straightforward:

-- (Note that you need to order by Amount DESC to ensure the values are in row...

Try this:

--==TEST DATA ==--

use tempdb

go

drop table Persons

drop table Knows

drop table TakesClasses

create table Persons (id int, name varchar(50))

insert into Persons values (1, 'Fred'), (2, 'Bill'), (3, 'Mavis'), (4, 'Arthur'), (5, 'Jill'),...

How about this:

;WITH CTE AS

(

SELECT *, RN = ROW_NUMBER() OVER (PARTITION BY OrderID,ProjectID,ProductID ORDER BY OrderID,ProjectID,ProductID, Amount DESC)

FROM #projects

)

SELECT OrderID

,ProjectID

,Project

,ProductID

,Product

,Amount = CASE WHEN RN = 1 THEN Amount ELSE 0...

Homer

Head

Hi. You need to provide test data so people can easily test your problem... like this:

--Here is the following Data Structure of tbltestnew1

use [tempdb]

go

if object_id('tbltestnew1') is not null...

How about this:

SELECT Customer, [Type], DueDate1, DueDate2 FROM dbo.myTable mt

WHERE mt.[Type] = @Type

AND ((@Condition1=1 AND mt.DueDate1 BETWEEN @DueDate1 AND @DueDate2) OR (@Condition1<>1))

AND ((@Condition2=1 AND mt.DueDate2 BETWEEN @DueDate1 AND @DueDate2) OR...

Rubbish

If you run the package using DTEXEC, you can change the connections at run time using a parameter (/CONN) - so that might work.

lunchbreak

Have you got the SQL table definitions?

Girl