Okay, now we really need that Porky the Pig picture with him say move along, nothing to see here. The OP is "closing the thread". Like he was...

dwain.c (4/17/2012)

---

Lynn's query returns only one row:

DCODDName

J6598JOHN

Which may be what you want. However if you want all of JOHN's records, you can use this:

DECLARE @t TABLE

(DCOD CHAR(5), DNAME...

Glad to help.

Any one have a picture of Porky the Pig telling everyone to move along, nothing to see here? That would be a good post to end that thread on.

CREATE TABLE dbo.three_columns

(

A INT NULL,

B INT NULL,

C INT NOT NULL

);

GO

ALTER TABLE dbo.three_columns ADD CONSTRAINT [ck_dbo.three_columns.C] CHECK

(

(C < 150 OR C > 151)...

ScottPletcher (4/17/2012)

---

Is that really necessary?

Won't SQL treat computations on a declared variable as a constant, so they are...

ScottPletcher (4/17/2012)

---

Is that really necessary?

Won't SQL treat computations on a declared variable as a constant, so they are...

GilaMonster (4/17/2012)

---

The "Mr I don't have a clue" thread is starting to resemble a pile-on. Maybe better to just ignore him or at most one post from one person when...

Sean Lange (4/17/2012)

---

Here is an example with some data.

--these are your parameters

declare @date1 datetime = convert(datetime, '20120201')

declare @date2 datetime = convert(datetime, '20120406')

select @date1, @date2

--now we want a variable to hold...

jerome.morris (4/17/2012)

---

Lynn Pettis (4/17/2012)

---

Here is some code to try:

SELECT

Con1,

Con10,

Con2,

Con3,

Con4,

...

Also, before posting questions, please read the article Forum Etiquette: How to post data/code on a forum to get the best help[/url]. Follow the instructions provided in that...

Here is some code to try:

SELECT

Con1,

Con10,

Con2,

Con3,

Con4,

Con5,

...

Read the article Forum Etiquette: How to post data/code on a forum to get the best help[/url]. Follow the instructions provided in that article and give us the DDL...

hbanerje (4/17/2012)

---

for example I have a table, which has ID, Service, Subservice cols.

I want to modify or change 'Surgery Service' to 'XXX-Surgery' for the "Service" col where ID = 123,

and...

Nice, ddl for the tables. Now you need sample data (as a series of INSERT INTO statements) and expected results.