Viewing 15 posts - 4,291 through 4,305 (of 6,486 total)
The report Models are pseudo-universes (a la BusinessObjects) allowing the designer to create a "simplified" environment for their end users to create ad-hoc reports. You add tables/views, draw the...
March 10, 2008 at 8:59 am
Also - one parting thought: how to lay out the printed invoice (to show them the "right" amount) is altogether a different "issue" than calculating the invoice amount for the...
March 10, 2008 at 8:51 am
I guess the question comes down to laying out all of the business rules. The rounding is something that needs to be handled correctly, but if it is -...
March 10, 2008 at 8:47 am
Jeff Moden (3/10/2008)
That's a pretty awesome machine...
It's amazing the amount of hardware you can get these days...I just got the AMD equivalent of that machine for $329. Double the...
March 10, 2008 at 8:33 am
ALZDBA (3/10/2008)
Sergiy (3/9/2008)
SELECT @SaleAmount = @SaleAmount * (1-Amount)FROM dbo.Temp_Discount
ORDER BY OrderID
There is a very nice must read article bij Jeff Moden regarding this construct.
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
Speaking of the "running aggregate" method -...
March 10, 2008 at 8:12 am
sharon (3/9/2008)
why is it said incase of internet we need to use...
March 9, 2008 at 8:31 pm
Jeff Moden (3/7/2008)
Wow this thread reminds me of my last interview. I was asked what is the fastest way to clear a table.
BWA-HA-HA-HA!!! Oh, the poor fools that last...
March 7, 2008 at 3:25 pm
What's the memory situation of that server? Sounds to me like a leak not releasing resources.
Have you had a chance to reboot it recently to see if you can...
March 7, 2008 at 3:21 pm
Cliff Jones (3/6/2008)
http://support.microsoft.com/kb/942444/
We have seen several instances...
March 7, 2008 at 1:52 pm
Create a new ASP.NET web project. You should just see them in the toolbox when you do that.
March 7, 2008 at 1:42 pm
Jeff Moden (3/7/2008)
Sorry... I can't read Spanish...
All right smarty....He's pointing at the BOL entry for OPENQUERY...
http://technet.microsoft.com/en-us/library/ms188427.aspx
Both OpenQuery and OpenRowset need "static" SQL to run. you can't pass a variable...
March 7, 2008 at 1:39 pm
Roberta -
to be exact - you're asking it to show you all of the product names of products in the 'Beverage' category (or categories, since given the it's written...
March 7, 2008 at 1:01 pm
Hmm. I'd love to see that one in writing, because Dev licensing states 49$ (US) "per user...Testing, developing, and designing"...That would be one for the Licensing gurus to take on...
March 7, 2008 at 12:44 pm
Lynn Pettis (3/7/2008)
Geez, Matt, I wish I'd thought of using VM's! That is a perfect use of VM technology! Three cheers and virtual pint for Matt!:w00t:
😎
The only bad...
March 7, 2008 at 12:13 pm
Then try this one on for size: look at using VM's.
The host machine and the VM sessions it runs are not at all required to be "in synch"...
March 7, 2008 at 12:02 pm
Viewing 15 posts - 4,291 through 4,305 (of 6,486 total)