Also you still have to use the CASE statement I showed you a few weeks ago. That won't ever change.

if you do INsert into table (DiffReason) values (NULL), the default won't be used because you supplied a value (even if the value is null).

As I said... this is actually slower to run because you run it in a function (however so slightly). And you still have to type it for every column......

Why????? You got a magic way to call a function without printing its name??

select P.* into #temp from

(select convert(varchar,convert(datetime,Date_Lst_Iss),103), Part_Num from dbo.Part_Mast

where Part_Num LIKE (RTRIM('258095GB') + '%')) P

You meant select *? .

It would look something like this (untested)

SELECT NBUCMPNY, NBUDEPT, NCTBACCT, MIN(NCTBSACT) NCTBSACT, SUM(AYTDREVN) AYTDREVN

FROM dbo.NBUORDER

WHERE DMATCHDT...

How fast is it to fetch only lets say one month of data?

Can you move the order by on the client?

1 - Select ownerID from dbo.Houses GROUP BY OwnerID HAVING COUNT(*) > 1

2 - What do you need exactly??

Could you please clear this out? Is it 335K or 3.3 M rows?

SELECT O.XType

, O.name

FROM dbo.SysObjects O

WHERE ID IN (SELECT TOP 25 ID FROM dbo.SysObjects O2 WHERE O2.XType = O.XType order by O2.Name)

ORDER BY O.XType, O.Name

Ya we figured the part about the P 6 .

Where is the between datestart and dateend condition then??

It should be included in...

Now that disclaimer is too long... Can't remember the funniest posts ATM. Most likely when Sue tried to tick me, but I have no link.

in vb code:

Dim i as integer

i=0

while i<8000

currentproject.connection.execute "Insert into Numbers DEFAULT VALUES"

i=i+1

wend

and you don't need the dude column to make this insert that way.

Select DATENAME(M, GetDate())