you can not do this using SQL. You will have to either schedule a job to do this or create a Windows Service which will fire the delete query every...

Andras Belokosztolszki (8/20/2008)

johan.frisell (8/20/2008)

I want to reada textfile which will further on be used in a mail sent from the database.

To read this file i want to use the...

I am afraid your...

I think this should help

select id, Depreciation, Depreciation + isnull((select Depreciation from TABLE where id = (select max(id) from TABLE where id < x.id)),0) from

TABLE x

😀

arjun.tewari (8/20/2008)

The following script will give you the name of the SP, the name of the tables it references, and the name of the columns inside those tables used by...

Hi,

The following script will give you the name of the SP, the name of the tables it references, and the name of the columns inside those tables used by the...

if your ID values are random as shown in the data example, you will have to either iterate using a loop or use a cursor. If they are in an...

PhisycalOp referes to Physical Operations. Physical operators displayed in red indicate that the query optimizer has issued a warning, such as missing column statistics which is turn forces the optimizer...

check my query, I haven't casted the whole case but only the else part which was returning the INT value.:D

The reason is that right() function returns a string value where as case returns the highest precedence type from the set of types in when or else clause. Which, in...

Couldn't understand the question clearly. In the scenario that you have specified, you don't need a dynamic SQL, you can simply write:

SELECT * FROM Product P WHERE

P.ProductName Like '%'...

How about this?

create table #temp_table

(

ID int identity primary key,

number int

)

GO

declare @ss int

declare @ms int

declare @rand int

select @ss = datepart(ss, getdate())

select @ms = datepart(ms, getdate())

select @ss...

This table is not normalized please work on the database design. Once done, rest all will be a piece of cake.

I dont think that the problem is due to the CAST done to int because in thins case, you should get String or binary data would be truncated ERROR and...

sry, misinterpreted the question:)