Ok set this baby... Real world.

I have a table catagory fields are description, catID, typeID. parentID

another tables queryed with (make, model, yr, engine).

in the category table makes are typeid =...

yea, you don't need to use a comma as a field separator.

However if you have a "csv" file I would use SSIS to form the inserts.

If the data is massive,...

First off, I don't "struggle" with t-sql, I use it a lot.

A lot of what I have to do is use cursors, because of how my database is structured, and...

ok example sort of (my computer is sick so I can't give you something already done)

select name from mynametable where changedate > @yesterday

fetch from @sel into @name

while (@@fetch_status = 0)

begin

insert...

Gee lynn are you dense. Do I have to write it in t-sql for you to get it?

I don't like cursors.

wtf

Another point, why should someone that knows c# or vb and does it daily, have to learn t-sql.

Why can't t-sql accomadate that flavor of language just like the IDL compiler...

Ok here is what I would like to do:

run a query or view that gets a datatable (in t-sql) not c#

Then run through each record in the datatable that I...

cursors heh

Excatly my point.... So why doesn't t-sql accomodate sets?

Why would I need a cursor to do updates like ?

foreach(select * from table)

{

insert into othertable (field) value(myfield) ? Why...

I don't think it's my problem that sql server is so inefficient with the use of cursors. Maybe they should have designed sql server better eh?

Yes shortening of stuff would...

also instead of using cursurs like they are now, wouldn't it be easier to say:

foreach( select myfield from tbl where myotherfield > 3)

{

insert into myothertable (myotherfield) values (myfield)

}

I think it...

are you guys living in the cage of t-sql? :)))

well begin and end for one can be replace with { }

declare @whatever as int can be replace with

int @whatever

gee I...

Lynn Pettis (1/14/2009)

---

I agree with Gail. If you go this way, call it via an asyncronous call using Service Broker. This way you know that the users update...

GilaMonster (1/14/2009)

---

foxjazz (1/14/2009)

---

My direct question I think is why does the clr (sql ) prevent us from using the windows.net tools like sockets or udp sendudpmessage? And since it...

Is there a method...

noeld (1/14/2009)

---

foxjazz (1/14/2009)

---

What are the differences between these two versions of replication?

Also, if I create a subscriber snapshot database, and script it to subscribe to a publisher, when I go...