Here is the quote from the first paragraph there.

A common table expression can include references to itself. This is referred...

realvilla (6/18/2013)

---

I have some good news and some more good news and then some bad news. First, we found a 2008 database that we can use. Second, the...

Hi and welcome to the forums. I don't quite understand why you are using openquery for this.

There are a number of things that are causing this be far slower...

realvilla (6/18/2013)

---

I'm on version 2000 which is probably why I generated these errors when I tried to run your code. The good news is that SQL admin people are...

See if this article helps point you in the right direction.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

Hopefully you can understand what I...

SQLTestUser (6/18/2013)

---

Thanks for the reply,

i am looking for Null values and based on those null values i want to update a column in one of the tables. A trigger that...

OK there are a few thing that we still missing but I pieced together. First thing is in your original logic you updated the returns in order of delivery date...

To...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

I realize you have a solution but I would be remiss if I did not mention that you should consider separating this data permanently. You are storing two values in...

mahavidhya24 (6/17/2013)

---

create table marks

(

student name nvar char(50),

marks int

)

Insert into marks(student name,marks) values('ma ha',67)

Insert into marks(student name,marks) values('tuba',78)

Insert into marks(student name,marks) values('Deena',70)

Insert into marks(student name,marks) values('Oriya',90)

Insert into marks(student name,marks) values('saga',98)

select *...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

SQLTestUser (6/17/2013)

---

yes that is pretty easy to select them and check what value is there its just the update i am struggling with. here is the select

select P.Id,...

The ddl is pretty rough but I can make it work. You should always specify a size for varchar columns. Also, it seems like you could be using ints for...