Hi GSquared,

Could you please tell me how to use square braces.

Thanks

In addition to fraggle's solution, in case if you need the latest date inserted with respect to name considering the dates could be random instead of descending then the following...

Thanks everyone.

Oops,

Forget to add the script of how the function is used on the table to get the required data.

SELECT * FROM #Temp

UPDATE #Temp SET Output = dbo.ufn_ExtractNumbersFromText(3,Data)

SELECT * FROM #Temp

Thanks

Jeff,

I have used your script both in UDF and as a query. But the problem is when the table records exceeds 10000, there is a performance issue. It takes more...

Fine .. Lemme check with that..

Thanks

"You could query sys.tables in tempdb, but that isn't going to tell you what process created the table(s). " ..

This is what i need that you have mentioned .....

Thanks

Thanks. But could you be more precise?

Hi nagesh,

The solution you have specified wont work as it gets only the last row data and appends to your local variable.

That is for the example provided by ashy,

declare...

I believe this might help..

DECLARE @tbTemp TABLE(VCH VARCHAR(50))

DECLARE @vchOutput VARCHAR(MAX)

SET @vchOutput= ''

INSERT INTO @tbTemp SELECT 'T'

INSERT INTO @tbTemp SELECT 'E'

INSERT INTO @tbTemp SELECT 'S'

INSERT INTO @tbTemp SELECT 'T'

UPDATE

@tbTemp

SET

...

Hi,

I have considered an example for your problem.

DECLARE @vchTemp VARCHAR(10)

SET @vchTemp = '2.6'

SELECT CAST(CAST(@vchTemp AS NUMERIC(18,4)) AS INT)

-- Output : 2

SELECT CAST(CAST(@vchTemp AS DECIMAL) AS INT)

-- Output : 3

You can...

Can you give me a sample output of how the result should appear after querying your table.

-------------------------------------------------------------------------

To know how to ask questions and increase the chances of getting asnwers:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

To avoid deletion from child table you need give restrict delete in table properties as per the role. Like, You need add the existing role in the permissions section of...

Hi,

you can drop and create table the tblTest with backup of records.

1. Generate create script of the tblTest with latest modifications.

2. create a temp table (should be the old structure...