Hi ram,

In which format of the time you have?

7.30, 7:30, 7hours 30 min, so that its appears as 7:50

Hi,

The table schema haven’t the null, so that it’s happened some time,

Use the case statement to set this issue, like

select a.CID,a.trainingId,

(case when (a.nomFR = '') or (a.nomFR is null) then...

One of the options to get thro by OS level, log would capture in the MMC (Microsoft management console), in the event viewer, unless the disk clean up activity, the...

Hi,

Because the OP needs to get the unique identifier in every row insert!!!

Hi,

use the trigger to get the newid value

create table MYTABLE

(

col1 int,

col2 varchar (2)

)

CREATE trigger ins_trg_MYTABLE on MYTABLE

for INSERT

as

PRINT CONVERT(varchar(255), newid())

return

insert into MYTABLE

select 1,'A'

Hi,

try this

select a.* from tableA a

inner join

(select id,max([date]) [date]

from tableB

group...

Hi Jeff,

The OP needs to set the posted function (may created for another reason) to...

Hi,

For the sub total, the rollup method is best to achieve,

Or use this simple statement

select * from MYTABLE

union all

select col1+' TOTAL',sum(col2),sum(col3),sum(Total) from MYTABLE

group by col1

order by col1

Hi,

Try this

INSERT INTO wce_activity (uniqueid, createdate, reminderdate)

select user_id() ,getdate(),dateadd(m, 1, getdate())

or

INSERT...

Hi,

This @random string value is unique unless you pass...

Hi,

Unique string for the table/procedure

Declare @random varchar(10)

set @random = CONVERT(varchar(10), right(newid(),10))

apply this @random string in the table/procedure

Hi Abhijeet,

Big bucket mentioned code for random of the alphanumeric is fine, but not suit for the SQL 2000, you use the newid() to get the simple random like

select...

Hi,

Try to make all the four separate select statement in to one statement by using UNION operation. Like

Select 'Savings per Policy' as TYPE , subpolicy_name, SUM(CO2_savings) As total_savings

From #CO2temp

group...

--Today

SELECT convert(varchar(15),getdate(),103)

--Yesterday

SELECT convert(varchar(15),getdate()-1,103)

--LAST YEAR

SELECT convert(varchar(15),((dateadd(year,-1,getdate()-1))),103)

--Today

SELECT cast(convert(varchar(8),getdate(),1) as datetime)

--Yesterday

SELECT cast(convert(varchar(8),getdate()-1,1) as datetime)

--LAST YEAR

SELECT cast(convert(varchar(8),(dateadd(year,-1,getdate()-1)),1) as datetime)

--Today

SELECT DATEADD(day,DATEDIFF(day, 0, GETDATE()),0)

--Yesterday

SELECT DATEADD(day,DATEDIFF(day, 0, GETDATE()),-1)

--LAST YEAR

SELECT DATEADD(YEAR,-1,(DATEADD(day,DATEDIFF(day, 0, GETDATE()),-1)))