Not very elegant, I am still learning - but it works.

The first row is FeederStatus 0 as your initial post required, you can change it to start from 1 by...

mapperhd (9/30/2011)

---

Hi,

We have a double data entry process and want to compare the entries of one record in Table A to the duplicated entries in Table B (identical to TableA)....

amanmeet.mehta 46966 (9/30/2011)

---

We need to copy data from one table to another table but the other table is on a different server.

Please let me know in case any one has...

You can only insert data using a view if its referencing just one table, otherwise its ambiguous exactly where you want to insert the data.

A CTE allows you to encapsulate a result set of a query and run queries against it. The result set within a CTE is temporary and exists only in the...

Jeff Moden (10/1/2011)

---

BCP with a format file that uses the end of line characters as delimiters (as well as some others).

In actuality, that's not the "best" way... the absolute best...

mjbkm (9/28/2011)

---

OK - what is...

Sounds like the fill factor is high so it becomes fragmented quickly when you do insert, updates and deletes.

Have you tried lowering the 'fill factor'?

You can partition by department name and dense rank by salary desc like so:

select dense_rank() over(partition by d.dept_name order by d.salary desc) as 'rank', e.eid, e.employee_name, d.dept_name, d.salary

from employee...

Have you tried casting it as char and passing that to the stp?

Afaik you must have a select statement immediately after a CTE.

So you can see the DB in the drop down list, but you cant right click on it and see which files its pointing to?

Have you restarted sql server service...

Delete it and re-attach?

I can't think of a way to do it without using dynamic SQL:

declare @sql varchar(4000)

declare @coll varchar(128)

-- change the select to get your required collation names

set @coll =...

In SSMS:

Create the user with no extra roles.

As admin, right click on the User -> User Mapping.

Tick the database you want to map their username to, make sure only public...