there's two procedures that make it a bit complicated to convert to a set based operaiton, becaus3e both procs look like they fiddle with one row at a time:

[dbo].[UpdateFrequencyCheckNote]

[dbo].[CreateFrequencyCheckNote]

based on...

DBA12345 (7/3/2013)

---

Hi Lowell,

Thanks for your pormpt reply. But i do have 1000 records to macth in both tables. So, we have to put all the thousand values in the way...

this really sounds like homework....

anyway,

the nth highest , ie the second or third, requires...

you are going to have to cleanup the data, it looks to me;

in your example, using charindex, you only get a single match.

unless you can guarantee the three letter abbreviations...

i think granting VIEW DEFINITION TO {USER OR ROLE} , in a specific database, will give access to all the system views like sys.tables, etc, but not grant read/update to...

i also found this old scalar function that uses a Tally Table to find and replace, based on the ASCII code...

this actually does the replacements of À Á Â...

ok, i've done something kind of similar,and easily adaptable..

i'm guessing that, for example, you really want to replace any letters À Á Â Ã Ä Å with A, is that...

well, nested REPLACE functions are extremely efficient, even if they are wordy and make your eyes cross when nested more than a couple of times.

format them for readability, but the...

Jeff Moden (7/3/2013)

---

Since I'm no VB expert but still very curious, how...

also, i think you had your joins backwards...

this seems to show me everything correct:

/*SuperVisorManager1Manager2

ramNULLNULL

surehramNULL

vimalsurehram

*/

CREATE TABLE [#Employee](

[EmpID] [int] NOT NULL,

[EmpName] [varchar](50) NOT NULL,

[SupID] [int] NULL)

GO

INSERT INTO [#Employee]...

pretty sure SQLSACT is correct;

part of the update process is updating the indexes that are affected, so when the transaction is committed, bit the data itself and the indexes...

OUCH this is painful to even acknowledge I built this query, after seeing how dog slow it is!

my thought is the command has to look something like this, for every...

* also the Database Engine Tuning Advisor creates a trace with a NULL path, as well.

also I'm pretty sure a profiler created trace does not have a path: so you can do check sys.traces as a quick sanity check, and that would tell you...

As usual Sean's got it covered; about all i can say is null columns or tables with zero rows, is missing / no data often doesn't mean the objects can...