nmah (9/26/2008)

---

I have sql text that gets built on the fly as follows:

select univ from tblxxx where univ in('stanford', 'College of William and Mary')

The above works fine.

But the...

This is related to VB so post your questions at VB forums like www.vbcity.com

Ahmad Osama (9/25/2008)

---

Hi All,

I have to compile some 30-40 stored procedures at the client end.

Currently I am do this by compiling each proc one by one in a query...

What does this mean?

Lynn Pettis (9/24/2008)

---

There is another side to this. If the date fields are currently varchar(8) with the dates formatted yyyymmdd, what effect will changing the data type to datetime...

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

insert into test2

select * from test1 as t1

where not exists(select * from test2 where pk=t1.pk)

YYYYMMDD is ISO format which is fine

Make sure you use proper DATETIME datatype for your column

There is no need of convertion

Try using

(100.*

sum(case datepart(yy,t.orderdate) when 2008 then 1. else 0. end) /

NULLIF(sum(case datepart(yy,t.orderdate) when...

obarahmeh (9/24/2008)

---

well, I have a trigger that reads the latest inserted data and insert them into another table. I've wrote the trigger, then it inserted all data from the first...

Well. You didnt answer to my question 😉

You dont need additional replace function

See my first reply 🙂

Where do...

You are welcome 🙂

Also refer http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx