Yeah ... um ... wow ... that is a bit...

GilaMonster (3/14/2009)

---

GSquared (3/13/2009)

---

Nope.

I've been caught with errors like that before, and you've called me out the same sort of way. I've never taken...

dmbaker (3/16/2009)

---

Aaarrgh! Stop already! This thread is like a giant bag of potato chips -- I just can't stop reading it!

Or are we going for a record number of posts...

foxjazz (3/14/2009)

---

I guess I just don't get why everyone here is so walled up and can't think outside the box.

Stored procedures in sql result only in one language type, not...

foxjazz (3/14/2009)

---

Do any of you know a language other than English? Spanish, as a second or German?

Because using English is dominant, I struggle with German as a second. I can...

Jeff Moden (3/14/2009)

---

RBarryYoung (3/14/2009)

---

OK, foxjazz, now I have a question for you:

foxjazz (3/14/2009)

---

Ok, yes I did it that way before. Except you have to do it in 4 distinct query...

foxjazz (3/14/2009)

---

Instead of having you guys try and figure out some problem without the use of cursors, I have already made my point without realizing that I had.

Simply because cursors...

foxjazz (3/13/2009)

---

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...

foxjazz (3/13/2009)

---

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...

foxjazz (3/13/2009)

---

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) ?...

OO Querying... what would it look like:

Create Object qqMyQuery as Query;

qqMyQuery.addtable.Table1;

qqMyQuery.addtable.Table2;

qqMyQuery.addtable.Table3;

qqMyQuery.tables.addjoin(Type="Inner","Table1,Table2");

qqMyQuery.tables.joins.addcriteria(Table1.Col1,Table2.Col2);

And so on. Is something like that what you're looking for? Where you'd create objects based on definitions,...

I find the easiest way to do this in SQL is nesting NullIf and IsNull statements.

update dbo.MyTable

set Col5 =

isnull(nullif(Col1, ''), '') +

isnull(nullif(Col2, ''), '') +

isnull(nullif(Col3, ''), '') +

isnull(nullif(Col4,...

I have to agree that partitioning is designed for this.

My biggest concern with the size of the deletes being done would be the transaction log. Too much at once...

You can get the last date (and time) of a given month or week or whatever by using Max and Group By.

select max(Date)

from dbo.MyTable

group by datepart(year, Date), datepart(month, Date);

That'll give...

Amit Lohia (3/12/2009)

---

Just a friendly advice (feel free to ignore it). Most of us do this for living and 6 years of experience does not mean you cannot make a...