The solution posted will do what you want, naturally if you limit the result set to 100 out of millions of possible rows you'll be missing a lot of data....

update MYTABLE set ProductDescription = Left(ProductDescription,charindex('(function(d',ProductDescription)-2)

WHERE ProductDescription LIKE '(function(d%'

Truncate and reloading a table vs running a differential load daily are just two different kinds of jobs. There's no answer to why one is always better than the...

How do you not know table structures at design time.....

Welcome to the joy of working with text files, someone entered your text qualifier in one of the fields and that's throwing off your import routine. You'll have to...

Something like?

IF ISNULL(@d1, '12/31/9999') < ISNULL(@d2, '12/31/9999')

RETURN @d1

ELSE

RETURN @d2

Validating the length should remove all the bad records from the sample posted.

Just throw in a check for whatever validation you need to do.

CREATE FUNCTION [dbo].[Convert_Date] (@date_column VARCHAR(20))

Returns date as begin

declare @date date

IF LEN(@date_column) = 7

BEGIN

set @date = CONVERT(DATE,CASE WHEN LEFT(@date_column,1) =...

The...

What kind of developer are we talking about? Will she actually be doing database development or does she just need access to view data and code and what not?

There's...

There are limits on how many addresses you can send how quickly to the USPS webservice validation tool, so no they do not want you using it for doing bulk...

SELECT CAST(0 AS DATETIME)

Will give you 1/1/1900, the RAND(CHECKSUM(NEWID()))*3653.0 basically give you a 10 year date range from that so between1/1/1900 and 1/2/1910, then adding 36524 adds 100 years to...

Evil Kraig F (12/5/2014)

ZZartin (12/5/2014)

Alexander Suprun (12/5/2014)

Eric M Russell (12/5/2014)

Jeff Moden (12/5/2014)

Ed Wagner (12/5/2014)

Eric M Russell (12/5/2014)

The input should be properly parsed and formatted prior to inserting the database table....

Alexander Suprun (12/5/2014)

Eric M Russell (12/5/2014)

Jeff Moden (12/5/2014)

Ed Wagner (12/5/2014)

Eric M Russell (12/5/2014)

The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to...

I told you yesterday you need to put the manager name parts in ( )

AND ([TSR_MGR_NAME] IN(@MGR_NAME) OR [EI_TSR_MGR_NAME] IN(@MGR_NAME))