Luis Cazares (9/4/2014)

Sowbhari (9/4/2014)

Hi Luis C., could you please...

Hi Luis C., could you please explain a little...

You can find the code and the article in the below link

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Try the below code. You will need to have the DelimitedSplit8k function created. Please read the article here[/url] to understand how the function works and the code.

DECLARE @myvendedor AS varchar(255)

SET...

If you can hold the column data in a variable for which you want to replace special characters the below might work

DECLARE @a NVARCHAR(100)

SELECT @a =...

Will this help

;WITH Nums (i,j,k) AS

(

SELECT 1,4,2 UNION ALL

SELECT 1,6,2 UNION ALL

SELECT 2,4,2 UNION ALL

SELECT 2,6,2 UNION ALL

SELECT 3,4,2 UNION ALL

SELECT 3,5,2

)

SELECT B.j

FROM (SELECT COUNT(DISTINCT i) Cnt FROM Nums) AS...

Chris solution is obviously better than the below but if you do not want the seconds part then...

Try the below...

UPDATE A

SET A.MARKET_VALUE = B.MARKET_VALUE

FROM @Emp AS A INNER JOIN

(

SELECT 'DIVERSE' AS RISK_FACTOR,

SUM(CASE RISK_FACTOR WHEN 'ALL' THEN MARKET_VALUE*-1

ELSE MARKET_VALUE END) MARKET_VALUE,

CUT_DESC,PROCESS

FROM @Emp

WHERE RISK_FACTOR <> 'DIVERSE'

GROUP BY CUT_DESC,PROCESS

) AS...

You will need to specify the server name where the database MYdb is held

EXEC xp_cmdshell 'bcp "SELECT * FROM [MYdb].[dbo].[TB40] WHERE

LEFT (ZZ, 2) IN (''Is'', '''MS', ''OS'', ''SM'')

AND YEAR (MAX([theDate]))...

If you open the .dtsx file in a notepad, what does the text qualifier property show

<DTS:Property DTS:Name="TextQualifier" xml:space="preserve">_x0022_</DTS:Property>

OR

<DTS:Property DTS:Name="TextQualifier" xml:space="preserve">"</DTS:Property>

If it is the first option then try changing to the...

What are the TextQualifier & ColumnDelimiter properties set to currently?

Will this help...

DECLARE @Hourly INT

SELECT @Hourly = 1

SELECT Col1,Col2 FROM TableA

WHERE

(CASE WHEN @Hourly = 1 THEN TableA.LoadDateTime

ELSE CONVERT(VARCHAR(8),TableA.LoadDateTime,112)

END) >=

(CASE WHEN @Hourly = 1 THEN @TodaysDate

ELSE CONVERT(VARCHAR(8),@TodaysDate,112)

END)

May be there are non-printable characters in the code you might have copied from your script files that are not visible in SSMS. What happens if you open a new...

Check this link if it helps

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a790460b-9ef5-482b-b219-f55c05fa30d3/error-occured-while-skipping-data-rows?forum=sqlintegrationservices

This might not be the best solution...but it works on your sample data.

DECLARE @Id INT

SELECT @Id = 1

;WITH Hierarchy AS

(

SELECT * FROM @TransactionComponents

WHERE pktransactionid = @Id

UNION ALL

SELECT * FROM @TransactionComponents

WHERE...