Right now we r calculating for only one year

Hi,

Really fantastic.Thanx a lot . I have small doubt in this.

(ie.) eg.

If month is 4

Current value- (Qty1+Qty2+Qty3+Qty4)

forecast1 value- (Qty5)

forecast2 value- (Qty6)

If month is 5

Current value- (Qty1+Qty2+Qty3+Qty4+Qty5)

forecast1 value-...

Hello friend,

Really nice. i got exact result for current value. but forecast value is getting wrong result.

my requirement is

If month is 4

...

Here we cant change the table structure. b'coz already running in production server.so that only

Thank You

For Eg.

LocationID-23

This LocationID value may refer in many table. here i need to find, whether any table referred this value.

If i send TableName and LocationID...

Thanks for your reply. I have taken reference table and column already. But my requirement is, need to find whether particular Value exists in any reference table. How can i...

Thank you very much for all your precious reply, i have got some idea, regarding this. I have one doubt, if name lenght exceeds above 20 character.what can i do....

Hello friend,

Kindly try below one.

DECLARE @Table1 TABLE (ID INT , Employee VARCHAR(50))

DECLARE @Table2 TABLE (SourceFieldChar CHAR(1),Val CHAR(1) )

INSERT INTO @Table1

SELECT 1,'Ritesh' UNION ALL

SELECT 2, 'Bhatt'

INSERT INTO @Table2

SELECT 'R','X' UNION...

I have small doubt, Is there any performance issue to joining the query using views.Can you please suggest me.

when i am run your query, i am getting this error

The column prefix 'did.Location' does not match with a table name or alias name used in the query.

hello friend,

Kindly try the below one.

Declare @t table

(

a_id int,

a_add varchar(20),

a1_add varchar(20),

a3_add varchar(20),

a4_dt varchar(20)

)

Insert into @t

Select 1 ,'sameer','Mumbai','TEST','05/02/2010' Union All

Select 1 ,'sameer1','Pune','TEST2','08/04/2010'

Select * from @t

declare @xml xml

set @xml=(Select t2.a_id ,t2.a_add...

Hello Friend,

I have check the duplicate data like this.

if Exists (Select * ,@vVarTime

from @vShiftTable

where case when Convert(datetime,Convert(varchar(10),@vVarTime,108)) > '1900-01-01 00:00:00' and Convert(datetime,Convert(varchar(10),@vVarTime,108)) <= @vMultiDateTime

...

Can you please sample code

hello friend,

I have small doubt in your query.Why did u hard code the date like below

where case when Convert(datetime,Convert(varchar(10),@vVarTime,108)) > '1900-01-01 00:00:00.000' and Convert(datetime,Convert(varchar(10),@vVarTime,108)) <= '1900-01-01 05:59:00.000' then

This is...