can you please post the view?

dragos

u're welcome!

dragos

you could use this part for the conversion (hope to see better ways to do this 🙂 )

select convert(datetime, floor(convert (float, dbo.Fatura.DtFatures))), ........

...............

group by convert(datetime, floor(convert (float, dbo.Fatura.DtFatures))) ,......

you get those multiple results and no summing because the datetime values contain time info also

you should get rid of the time info (by whatever means you prefer), and keep...

if i understood your problem well, you could use something like this

select t1.A1 from test t1 join test t2

on t1.A1 = t2.A1 and t1.A2 =1 and t2.A2 = 4

you...

Toni, i should have quoted your first post 🙂 as i mine was referencing it

while your solution was (as far as i am concerned) very good for a non...

if your tables have PK - FK relationships, sqlserver will not allow you to truncate those tables

LE: maybe 🙂 i should have said that the command will fail against tables...

hi

probably there's a new application on your production server that is causing the growth.

tempdb grows when you create explicitly temporary objects like tables, table variable, sp and cursors

, when sqlserver...

are you using QA ? if 'yes' pls go to options -> results and check 'scroll results as received'

never used this but maybe it helps:

"FIRSTROW = first_row

Specifies the number of the first row to load. The default is 1. This indicates the first row in the specified...

i would choose DTS too 🙂

i could try to help you if needed

hi

if i understood your issue well....

you could do it

- in a DTS, with an Execute SQL task and a SendMail task and then schedule the package

or if...

Andy, that's the one i used most times... if not always. glad if it helps

if you need all trigers disabled, you can specify 'all' instead of triggername. i found it useful