Hi there,

This is a way of filtering based on time

create table #tmp(nos int,TranDate datetime)

insert into #tmp

select 1,'2009-07-02 05:41:00.000' union all

select 2,'2009-07-02 20:12:00.000' union all

select 3,'2009-07-02 14:47:00.000' union...

Hi wassup

Hi wassup

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Hi Mick,

As far as I can understand you need to assign the variable

for that you might try this

DECLARE @size_mdf int

DECLARE @sql_size_mdf nvarchar(100)

SET @sql_size_mdf = 'select @size_mdf=SUM(size)*8/1024...

Sorry Lynn,

It is #tmpGRN not tblGRINMaster. It somehow worked on my machine cause I had both of them. And as you can see I had put some...

Hi Jeff,

Thanks Jeff for replying. I am quite surprised to see such a keen interest. Although I am sorry for only posting part of the problem.

Talking about...

Hi Jeff,

Issue (Issue to dept/employee) of one single item may require to knock of balance qty of many grn's (purchase).

Like Issue Pen(50) - GRN1 10,GRN2 20 ,GRN3 20.

...

hey smsam1,

How about adding an 'ON DELETE SET NULL' constraint on foreign key column in team table?

hey smsam1,

How about adding an 'ON DELETE SET NULL' constraint on foreign key column in team table?

hey smsam1,

How about adding an 'ON DELETE SET NULL' constraint on foreign key column in team table...