masoudk1990 (7/5/2013)

---

Ive noticed dudes in this forum uses # for the first letter of their table names.

Does it have any special meaning?

Does SQL Server have different behavior with them?

Or its...

the limit's found in BOL, but its basically

select POWER(convert(bigint,2),31) -1

so a Varchar(max) stores a maximum of 2 147 483 647 characters.

yep, i'm confirming the same thing you are seeing,

i cannot map a domain group to a remote login, even if i know it exists as a login on the server.

i...

you also have to check for empty strings when converting to decimal as well

SELECT * FROM tbl WHERE ltrim(rtrim(col)) NOT LIKE '%[^0-9]%' OR ltrim(rtrim(col))=''

empty string converts to zero for...

because this seems a lot like homework, i only offered a partial SQL to help you think about the issue;

this doesn't pass a syntax check...

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]...