I am working on Empty warehouse table. [means data wont start from mid of week its always historical say last 3 yrs (since inception)]

I have 2 similar cases of this...

Hi John

I had gone through this great article but my requirement is slightly different.

I don't want to know what is left units & price but my main concern is for...

Hi John / Dave

Thanks for the link Dave, I had started coping the SQL codes & checking the flow, will let you know using this technique I can get my...

my R&D reached till this stage

Create Table #InventoryAudit

(

TransDate smalldatetime not null,

ProdCode nvarchar(1) not null,

TransType nvarchar(3) not null,

Qty float

)

insert into #InventoryAudit

select '2011-01-01','A','Pur',5 Union all

select '2011-01-02','A','Pur',8 Union all

select '2011-01-05','A','Sls',12 Union all

select...

I am getting this error

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'as'.

Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'as'.

while...

Thank you for your reply.

& one more question.

the earlier code given for index will suffice or should I go for advanced filtering like cluster or whatever.

but to be frank I...

should I create Index on all fields?

will this speed up my query retrievals??

Hi,

Thanks for all your replies.

I am using SQL only as a data backup & bulk data storage.

This sql is only for my local use & it does not have...

pl see the attached file where at one time my sqlserver.exe size goes to 113 mb & in next process it goes...

GilaMonster (7/18/2008)

---

Thanks for mentioning that you were running on SQL 2000.

That particular query would be helped by an index on datep, however I thnk you have bigger problems than one...

apart from row data as I told there is nothing in the same like Index or procedures or whatever.

& just now I put one simple query to extract the max...

Yes Sir

when I see windows task manager under process tab

image name shows sqlservr.exe under mem usage it goes upto 198,200 K

I have 512 mb ram on my pc &...

Thank u very much