You have to install "Management Components"....

In component selection, you have to select the component "Workstation Components, Books Online, and Development Tools" and from the advance option selection, you have to...

Just a little modification in the query....

Note:

This code assumes that there exists values "Funder" & "Industry" in the column. Otherwise, you have to manually handle those exceptions by filtering...

I think you have to remove the additional condition in WHERE clause....

CREATE TRIGGER Insert_ApprovedDate

ON Request FOR INSERT

AS

Update r

Set dateApproved = getdate()

From Request...

Its not about how close you can get, its...

Other way around is to split delimited values to rows and then take distinct of those values.

Jeff had written a nice article about using tally table to split delimited string...

I am glad I could help you...:)

There are many ways to transfer a database from one server to another...

1. Backup/Restore Method (recommended)

2. Transfer Database Task in SSIS

3. Copy Database Wizard

4. Using SMO Objects

I personally don't...

I think there must be something wrong with the data. I could have helped you a bit more if you provide some more information about the table structure and...

Have you checked by setting the "Label" property in "Chart Properties > Data > Category Groups > Group B > Edit .. > General > Label:" ?

Well, I don't think so one can enforce the said rules/permissions in a simple manner. If you want to strictly enforce those then I guess the only option left...

Jeff Moden (1/14/2009)

---

Ramesh (1/14/2009)

---

Jeff Moden (1/14/2009)

---

Never mind... not enough coffee... I see it. And, I agree with Seth... unless you have some additional information, this is definitely not the...

Jeff Moden (1/14/2009)

---

Never mind... not enough coffee... I see it. And, I agree with Seth... unless you have some additional information, this is definitely not the way I'd output...

There are many articles on this forum about concatenating strings.

Here is an excellent article by Jeff Moden on it

http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

You have not provided enough information to help you. If you want a better and a quick solution, help us by providing table structures in form of DDL, sample...

How could you tell that these are the last 5 orders?

Will it be possible to return the last...