Here is my two cents:

/*

SELECT * FROM [WM_Reading]

SELECT * FROM [BPM_Reading]

SELECT * FROM [Patient]

*/

DECLARE @PatientID INT

SET @PatientID = 1002044

; WITH BPM_CTE AS

(

SELECT -- List of Columns that...

Thanks for the feedback, DBTeam... 😀

Would this do ?

DECLARE @MyTable TABLE (MyNumericVal VARCHAR(100))

INSERT INTO @MyTable VALUES ('50.10-'),

...

Nakul Vachhrajani (9/14/2010)

---

Completely generic - no CAST/CONVERTS...

DECLARE @MyTable TABLE (MyNumericVal VARCHAR(100))

INSERT INTO @MyTable VALUES ('50.10-'),

...

Cross post.. please provide ur solutions at : http://www.sqlservercentral.com/Forums/Topic985259-338-1.aspx

LTRIM & RTRIM from the above post forced me for this:

SET NOCOUNT ON

DECLARE @NegativeNumeric VARCHAR(100)

SELECT @NegativeNumeric='50.10-'

SELECT @NegativeNumeric = -1 * CAST ( REPLACE(LTRIM(RTRIM(@NegativeNumeric)) ,'-','') AS DECIMAL (10,2))

SELECT @NegativeNumeric AS [ConvertedToNegativeNumber]

SELECT...

Another dig:

SELECT @NegativeNumeric = -1 * CAST ( REPLACE(@NegativeNumeric ,'-','') AS DECIMAL (10,2))

SELECT @NegativeNumeric AS [ConvertedToNegativeNumber]

My two cents:

SET NOCOUNT ON

DECLARE @NegativeNumeric VARCHAR(100)

SELECT @NegativeNumeric='50.10-'

SELECT @NegativeNumeric = -1 * CAST ( LEFT (@NegativeNumeric , (LEN(@NegativeNumeric)-1)) AS DECIMAL (10,2))

SELECT @NegativeNumeric AS [ConvertedToNegativeNumber]

Here's my dig :

(using the table set-up by malleswar_reddy)

;with cte as (

select name,company,Email ,Id,RowCnt = COUNT(*) over (partition by company,name)

from #temp

)

Select Name, Company, Email,Id

From cte

WHERE RowCnt > 1

ORDER BY...

I think i know how to do that, but i need clear "expected output"...Where do u what the count column to fit it? Can u please be more specific with...

jpdlp (9/8/2010)

---

Hi all .

The attempt i made without taking in consideration this 'Enable' part was the following:

SELECT MP.* FROM [T_APP_ModulePermition] MP

INNER JOIN T_APP_UserGroup_Detail UGD ON MP.UserGroup=UGD.UserGroup

INNER JOIN T_APP_User U...

Chris Morris-439714 (9/6/2010)

---

Nope, it's an unsupported use of variable assignment which yields unpredictable results and has already been covered on the forum...

sreecareer (9/6/2010)

---

Thank you for the quick reply...

I think, I need a global temp table because I am using EXEC('query') also in the SP to insert to the temp table. If...

Provide sample data as per this link : http://www.sqlservercentral.com/articles/Best+Practices/61537/

You will receive tested , optimized, beautified code..there are coding beasts 😀 that reside in this site which will provide u with...

Are we in for a Connect Item ?