saltpepo (12/1/2012)

---

Hey hi dear..

I want this output using dense rank eliminating repeating binder no

OFFICE_ID BINDER_ID BINDER_NO denserank

2105110 10 ...

Check out this article: Creating a comma-separated list (SQL Spackle)[/url]

The evaluation version is the same as the enterprise edition. You will have to uninstall the evaluation edition and reinstall the standard edition.

pooya1072 (11/30/2012)

---

hi

i create a user in sql server 2008,i login with it .(it has sysadmin and public server role)

with this user i try to grant a permission to...

If you are talking physically different hardware (could be two separate VM's on the same box as well), then they can be the same. If the instances are on...

Rob Schripsema (11/30/2012)

---

Yes, there are. That is, there are other inserts and updates that can only occur if there was sufficient funds in the account to cover the transaction.

However, is...

Or, if you are doing an update, look at the end of this:

DECLARE @TestTable TABLE (

City VARCHAR(64)

);

INSERT INTO @TestTable

...

This:

DECLARE @TestTable TABLE (

City VARCHAR(64)

);

INSERT INTO @TestTable

( City )

VALUES

('Augusta, GA'),

('Denver, Colorado'),

('Trenton, Nj'),

('Silao, Guanajuato'),

('Sioux Falls, Avera Hospital'),

('Reno, Nevada'),

('Fort Bragg,...

Something like this:

DECLARE @TestStr VARCHAR(20) = 'Atlanta, GA';

SELECT

@TestStr,

CHARINDEX(',',@TestStr),

LEN(@TestStr),

LEN(@TestStr) - CHARINDEX(',',@TestStr),

STUFF(@TestStr,CHARINDEX(',',@TestStr),LEN(@TestStr),'');

The following link should help you understand data type precedence better:

http://msdn.microsoft.com/en-us/library/ms190309(v=sql.100).aspx

Danah (11/29/2012)

---

Thanks, yeah, that is it.

It seems a bit odd to grant granular permissions to create objects at the database level, and then grant a blanket alter permission at...

UncleBoris (11/29/2012)

---

thanks, I see the conversion but what I do not get at this point is if a conversion is made then why wouldn't a SEEK happen like if there...

Jeff Moden (11/29/2012)

---

Lynn Pettis (11/28/2012)

---

Combined some of the code from your code in this article with your delimited split routine to solve a problem at work. Inspiration comes from...

Okay, it isn't CREATE on the schema. From BOL regarding CREATE PROCEDURE:

Permissions

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

Requires CREATE PROCEDURE permission in the database and ALTER permission on the schema in which the procedure is...

Danah (11/29/2012)

---

Hi, I want to give a user permission to create tables, views and procedures, but only in one particular schema.

Here is what I read (at http://msdn.microsoft.com/en-us/library/ms191291.aspx):

ALTER

Confers the ability...