The only problem is that I have to parametrize my function statement which sucks and is not that readable.

Thank you Michael,

I just found out a possible work around for this issue. I could be wrong as well

CREATE FUNCTION dbo.xTest ( )

RETURNS @tbl TABLE ( x int, name varchar(100)...

Say for example, if you have type 2 updates and you just wanted to know that which records are the latest in your table, you could do so by using...

Nice article. Gives me another way to de-dupe data. 🙂

I use almost the same technique, but I have a time stamp associated with each record and this time stamp differs...

Thanks Jeff,

I think I will try to create computed column in temp table...

;WITH temp AS(

SELECT ID,

(isnull(CONVERT(char(2),CC), (CASE WHEN YY Between 80 and 99 THEN '19' ELSE '20' END)) +

CASE WHEN YY < 10 THEN '0'+ CONVERT(char(1),YY) ELSE CONVERT(char(2),YY) END + '-'+

CASE...

I have 4 columns CC, YY, MM, DD and they have records like

'20', '10', '5', '23'

To make this work as a time stamp, I have the following query

;WITH temp AS(

SELECT...

@jeff

Its not the temp table that has 4 columns. The source (which is a view being populated in real time and having no constraints/joins whatsoever) has 4 columns...

@jeff

I agree I stripped down the code for posting purpose, but the actual code definitely works. The whole reason behind combining data from 4 columns is that if...

The source for the above query is a view which has 96 columns approx and doesnt have any other object associated to it. Its just your "plain jane" view which...

The result of this query is inline with expectations, but the query time is ridiculous. I need to run it under 20 mins. Thats not a requirement, but running queries...

the startdate and end enddates have table preceding them in the query.

I have 4 columns CC, YY, MM, DD and they have records like

'20', '10', '5', '23'

To make this work as a time stamp, I have the following query

WITH TEMP AS(

SELECT...

I did connect to the Integration Services engine. As you said, one can see what packages are there in the MSDB. But yeah, no one can edit them here.

You cannot view it directly in SSMS. I tried it, but no result. Only way to edit a package or view it is in BIDS or Visual Studio. If anyone...