Interesting problem and thanks for the feed back...

Now, what's an "SQLDataAdapter"??? :blink:

It's great code! But only if you're inserting 1 row at a time from the GUI. 😉

Chaohua Wang (10/5/2006)

---

This error may not cause your system down. The database tempdb is automatically shrunk normally. There is an "bug" here. We may get an error message if a...

The numbering system is flawed to begin with... 003.31 should not be the child of 003.3... they're both at the same "level" in legal numbering. If 003.31 is the...

Michael is quite correct... if the 1099's end up becoming your main income or they exceed certain amounts, you MUST pay estimated quarterly taxes... do consult a good accountant! ...

Yup... easy to do if no foreign keys... of course, if these IDENTITY columns are being used as the PK...

Yeah, uh-huh... what...

Favorite temp table name... #MyHead 😀

Heh... "It Depends" 😉

Table size went up because instead of just storing text pointers, you are now storing the data itself... that, of course, takes extra room. In fact, you now have...

Exporting to spreadsheet is "Death by SQL"... if someone opens it, BOOM! Process in SQL is dead... period.

This will do it...

declare @temp table (t int)

insert into @temp

select 234000 --.65

union all

select 2052000 -- 5.7

union all

select 1638000 -- 4.55

union all

select 1620000 -- 4.5

select *, t/36000.0 ,t/36000

from @temp

WHERE t/36000<>t/36000.0

Adrienne (1/8/2008)

---

Is this what you are looking for?

declare @temp as table (t int)

insert into @temp

select 234000 --.65

union all

select 2052000 -- 5.7

union all

select 1638000 -- 4.55

union all

select 1620000 --...

July (1/8/2008)

---

I have to reach another server to copy a lot of file (100 files for 1 GB). I try with

EXEC xp_dirtree "\\machine\shrarename" but I obtain "system cannot...

SELECT Part, MAX(Date) AS Date

FROM yourtable

GROUP BY Part