Viewing 8 posts - 1 through 8 (of 8 total)
Thank you Jeff.
Of course I was looking hint and not answer. I am sure this will help me and if I am stuck then will get back to you/forum.
Actually I...
January 13, 2010 at 7:37 am
Hi,
Is it possible to create this dynamic? So that if any new territory add then it create new column automatically?
For ex If 16 = Territory6 then without changing code I...
January 12, 2010 at 11:19 am
Thank you very much to both of you!
December 14, 2009 at 9:47 pm
Thank you very much to both of you!
December 14, 2009 at 9:31 pm
No...it doesn't work.
I need item number of the same row which got max cost.
For ex : for this set of data
100004 0.507850786
1000040.258290696
1000040.260549999
1000040.397850786
result :
1000040.507850786
BUT, above query returning
1000040.508290696
October 23, 2009 at 11:10 am
Thanks Ray!
Yeah I used openrowset in sql and it works. At the moment I have fixed number and name of columns so using predefined format file but still trying to...
December 31, 2008 at 10:38 am
Viewing 8 posts - 1 through 8 (of 8 total)