Viewing 15 posts - 1,021 through 1,035 (of 1,825 total)
GilaMonster (2/17/2010)
Dave Ballantyne (2/17/2010)
eshreya_support is overdoing it a bit , reported a few as spam
I'm cleaning up behind, reported one and noted the whoever gets the report to check everything...
February 17, 2010 at 7:38 am
eshreya_support is overdoing it a bit , reported a few as spam
February 17, 2010 at 7:23 am
Bru Medishetty (2/17/2010)
Any one wants to answer few interview question ?
There must be at least a dozen more than that , is there such a concept as spam questions ?...
February 17, 2010 at 6:47 am
Jeff Moden (2/16/2010)
The void process I'm familiar with in the U.S.A doesn't actually do a "void"... they create a record with the negative value of whatever the transaction was (positive...
February 17, 2010 at 4:58 am
This may be a better example. Inside SQL there is no good way of doing this.
What FrontEnd software are you using ?
If nothing else , it is quite easy...
February 17, 2010 at 3:31 am
The 'problem' imo with pivoting data internally in SQL is that , by definition, a table and therefore a resultset has to have a finite and known number of columns....
February 17, 2010 at 3:01 am
Paul White (2/16/2010)
If you do this, be sure to check your implementation after upgrades and service packs etc. to make sure nothing important has changed.
Good Catch.
TBH im surprised that there...
February 16, 2010 at 5:25 am
You could write you own version of sp_replmonitorhelpsubscription , its not an encrypted procedure.
February 16, 2010 at 4:46 am
akshaycjoshi (2/16/2010)
Please provide a detailed explaination.
First you provide a detailed question.
February 16, 2010 at 4:33 am
here one method
with cteWithRown
as
(
...
February 16, 2010 at 4:31 am
Hamid-Sadeghian (2/16/2010)
user before archiving can change this number,but after archive the vouchers,cannot change this number.
So upto the point of archiving the number is irrelevant , correct ?
Why not allocate an...
February 16, 2010 at 3:54 am
Relook at my example before.
See the t2Id column on the #t2 table ?
Thats an identity and is a unique incrementing integer.
February 16, 2010 at 3:48 am
jyoti_bhatt (2/16/2010)
Rate_uno needs to be an incrementing and unique number e.g. max(rate_uno)+1.How would I simply insert data and setting this column e.g. max(rate_uno)+1?
Ill repeat my question from earlier , why...
February 16, 2010 at 3:35 am
Viewing 15 posts - 1,021 through 1,035 (of 1,825 total)