Chris,Grant..

Thanks guys I was kind of too sure the statement was right.

Came in the morning with a fresh brain and fixed it :rolleyes:.

The app for one reason or the other...

Chris why do you reckon this

select COUNT(*)

from companies where

code=@code and openedy=@openedyr and openedmonth=@openedmont

would return 2 rows?

If i send the paramters 01,2007,12 i do get a single row

If i'm...

sample data:

select company,code,openedyr,openedmonth from companies where code=@code and openedy=@openedyr and openedmonth=@openedmonth

company code openedyr openedmonth

-------- ----- --------- ------------

microsoft 01 2007 12

sun...

Thanks Lynn.

I just read that.

I was sure i was clear enough.

I simply have an insert and update statement in a stored proc.

I want to update and then insert the...

Nope that didn't help either.

I just want to update a row and insert that row into another table.

Lynn Pettis (11/24/2008)

---

Insert into c

a,b

select

@a,@b

from table where

not(a=@a and b=@b)

does that...

What i'm saying is it doesn't work 🙂

You are sending the same code i posted LOL :doze:

krayknot (11/24/2008)

---

Patrick Ige (11/24/2008)

---

Thanks Kraynot but if i insert GO

I would have to declare...

Thanks Kraynot but if i insert GO

I would have to declare all the variables

Pls test it.

krayknot (11/24/2008)

---

Patrick Ige (11/24/2008)

---

I have and update and insert statement in a stored proc...

What i want is to have a nested grid.

The master grid should...

THanks guys but what i need is

not in ('TX','NY,'MN')

I want to remove some more...

Will != or <> permit this?

rbarryyoung (11/11/2008)

---

Patrick Ige (11/10/2008)

---

select distinct(area) as

from Stores where state...

Nope no idea yet and no solution

Fixed it and blogged it here:

http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx

I'm having the same issue.

Can you explain where i would have to put that code?

The calendar is displaying dates in american format i want it in Asutralia format.

I have set...

Don't totally agree with Don.

But i agree wit the last post.

Use XML when you need it.

No doubt about it XML is good.

Thanks for the reply.

I have done eaxctly what you posted.

Sorry i didn't mention that i would like to do this from an asp.net page

using a localreport or a serverreport.

But my...

Thanks Jason...

I was just blind and i think :doze: