asranantha (6/15/2012)

---

Hi i have small doubt in sql server.

supooste a table data contains like

...

Another option is to look into the max memory setting for SQL Server. You can lower that, but be wary that when you do it may affect performance. ...

Nadrek (6/15/2012)

---

While the other answers will help you do what you're currently doing, I would suggest that what you're doing is a horrifically bad idea security-wise.

What I would suggest instead...

David Webb-200187 (6/14/2012)

---

Download the express edition of SQL Server ( or better yet, spring for the $60 and get the developer edition) and play with them at home. There's...

lol No problem! The ranking functions are on my blog (sqlknowitall.com). I haven't really been good at updating it since I recently started it and am not good at...

And please don't misunderstand... We are not saying that you are lying or incompetent or anything. We are saying that something is unbeknownst to us AND probably you that...

Try this:

USE tempdb

GO

DECLARE @Quality_Monitoring_RowSequence TABLE

(ref nvarchar(60)

,SAMPLE_ID int

,SAMPLE_DATE datetime

,template_descr nvarchar(512)

,template_id int

,STARTING_DATE datetime

,FREQ_UNIT int

,FREQ_VALUE int)

INSERT INTO @Quality_Monitoring_RowSequence (ref, SAMPLE_ID, SAMPLE_DATE, template_descr, template_id)

SELECT 'Churchill Treatment Plant', 13334, '2011-09-03 00:00:00.000', 'Treatment Works final...

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports...

Ok, here is my assembly of your sample data. Let me continue to work on a solution. Have you tried anything yet?

USE tempdb

GO

DECLARE @Quality_Monitoring_RowSequence TABLE

(ref nvarchar(60)

,SAMPLE_ID int

,SAMPLE_DATE datetime

,template_descr nvarchar(512)

,template_id...

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no...

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right now, just put...

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right...

Thanks for that. Maybe you didn't see my post directly before yours, but after my first post... Can you please post the create table statement for the table? ...

Use the OR operator?

select make, model, year, location, agent

from Rentals

where status = 'returned' OR status = 'rented'

My guess is that by the time you combine them all you will...