Something like this:

--CaseID: Comments: Userlogin

--1243546457 Great help UserA

--3123234353 AWESOME UserB

--2131314242 Support was terrible UserC

--2131314242 Support was terrible UserC

--2131314242 Support was terrible UserC

--2131314242 Support was terrible UserA

--3453453453 Could have been better...

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"

Well, I've just seen the equivalent...

SQL Server Management Studio. Just happens to be the main tool we all use when working with MS SQL...

The one thing I would suggest reading about is the MERGE statement. This may be what you really need.

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

alan_lynch (3/6/2013)

---

Ok Lynn if thats what you want to do and move on and help someone else then thats fine.

I am new to SqlServer so I dont know how to...

alan_lynch (3/6/2013)

---

Sorry Lynn

The BigTable.software_name_raw contains

SOFTWARE_NAME_RAW

Microsoft Office 2003 Professional Edition, Office 2003 Professional

Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional

Microsoft 2003 Office Professional, Office 2003 Professional

and the RefTable contains a...

For better answers to your questions, read this: http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Do you know what would really help, besides direct access to your system? The DDL for the table(s), some sample data for the tables, the expected results of the...

Do you know what would really help, besides direct access to your system? The DDL for the table(s), some sample data for the tables, the expected results of the...

TheSQLGuru (3/6/2013)

---

Jeff Moden (3/6/2013)

---

TheSQLGuru (3/6/2013)

---

The UDFs are a problem if for no other reason than the optimizer cannot know what is coming out of them, thus it will get inaccurate...

First, you will need the following itvf function. Read the comments thoroughly and then read article and its discussion. There is a lot of great information in it...

kk1173 (3/6/2013)

---

Following is the code for the function. For the previous query i had stripped this function and was directly running the IN clause. I did not notice any difference...

is250sp (3/6/2013)

---

In my dataset I have this script. Report parameter @acct is set as multi-value. When I select a single value it runs fine, however when I select...

Are the schemas owned by the principal?

select * from sys.schemas;

Possible change in the ownership chain. Who owns the view and who owns the underlying table(s)?