This works:

[Code]

Declare @tempt table (tblid int identity, tblchar varchar(5))

insert into @tempt (tblchar) -- load some data

select 'abcd' union all

select 'bcd' union all

select 'cd'

delete T

from...

grkanth81 (12/17/2007)

---

i am having data something like this:

number ...

This topic is named improperly.

There is no any problem with datetime.

The only problem is with column not being datetime.

Make it datetime and the problem will disappear.

Or you may find dependencies from system table sysdepends.

No subqueries!

SELECT LEFT( str_Sitename , 3) AS SiteName

, YEAR(dat_UsageDate) AS [YEAR],

SUM(Case MONTH(dat_UsageDate) When 1 THEN dbl_FuelUsage ELSE NULL END) AS Jan,

SUM(Case MONTH(dat_UsageDate) When 2 THEN dbl_FuelUsage ELSE NULL END) AS...

How often the table is changed?

If more than 2 times in a lifetime you better rethink you application design.

And you don't need 2 statements for...

From BOL:

if a trigger is defined as an INSTEAD OF INSERT trigger for a table, and the trigger executes an INSERT statement on the same table, the INSERT statement executed...

Matt Miller (12/12/2007)

---

That's not the behavior that's happening here. With both nested triggers AND recursive triggers on (and restarting the service just to make sure) - it fires once...

Is it SQL2005 BOL?

Because I'm thinking about writing a book discussing errors in SQL2005 BOL.

Appears to be quite...

Well, what's gonna happen when you execute

[Code]

insert into real_table --will get posted to the current table regardless of type

select col_list

...

I just did something like that today - using a staging table - the 1M or so records took 13 seconds to finish. You'll be lucky if you can...

I guess you need to read about osql utility in BOL.

Pay special attention to -i and -b parameters.

Reading Help helps a lot.

PatrickSimons (12/12/2007)

---

I think your approaches should work (I didn't test it yet), but nobody answered my question: why does my SubSelect on Table1 not work?

Is the SQL-Engine not so intelligent...

I would not say the article is rubbish (getting older? 😉 ), but I have to say it's far from being good.

I tend to agree with Jeff, it's probably the...