rfr.ferrari (6/6/2011)

---

this prevent duplicate, if target table is empty!!!!! I read...

This is functional but does NOT prevent duplicate data from getting into the destination as Paul's script does.

Not really sure what you trying to do but here is a start.

select * From fn_my_permissions(NULL, 'DATABASE')

creating a login is no big deal at all. Just google it. Not sure what you mean about "then login to SSMS". Are you meaning you want create a new...

You should take a look at this article[/url] about catch all queries on Gail's blog. You might also take special note of the section about sql injection as the procedure...

something like this should you what you are looking for. Notice how i created some ddl and sample data to make this easy for others to test. To paraphrase Wayne,...

WOOHOO!!! Beers all around!!!!

The Dixie Flatline (6/2/2011)

---

Thank you.

You are defining your course titles as NCHAR, which means they are padded with blanks on the right to the specified length. NVARCHAR...

Can't move them. :hehe: No worries, apparently I am in on of "those" moods.

At any rate, just before you delete the table of your duplicates you will need to send...

If you actually provide some sample data (more than 1 row) either Dixie or myself can help in a matter of seconds. Otherwise the best either of us can do...

With 258 points I would think you would know enough to post more info (and maybe even post a sql 2000 question in the correct forum). This is really vague...

applebutton (6/2/2011)

---

sql server 2008 deriving another column based on other calculated column in SQL Query:

select emp_id, emp_salary_bonus = case some condition,

derived_column = case when emp_salary_bonus <1000 then 1 else...

Please take a look at the first link my signature for best practices on how to post a question in such a way that you will get the results you...

After a quick search with your EXACT question i was returned a previous thread on this forum as this first item returned. Try the article here to see how this...

I have to say that sounds like a really bad idea. You are in effect using Excel as a UI for a data application. How do anticipate validating input? There...