RE: subtraction of column doesn''''t work correctly
The view I pull off of v_MTSTM_ProfitLoss actually converts the table datatype of FLOAT to a SMALLMONEY (columns Carrier_Pay and Customer_Charges). There are no nulls at all.
2005-01-14
unit testing
2004-12-23
RE: Edition of 6.5 - How do I find it?
I believe 6.5 only had Std and Enterprise editions. If select @@version doesn't return it, I'd look through the registry keys (HKLM/Software/MS/SQL Server) for it or properties of the server in Enterprise Manager.
2004-10-11
RE: Error in restoring database
Is this on Yukon !!! The question seems to be on SQL 2k. Why is this on this forum ? Do you get the same error on Yukon.Vinod Kumar
2004-09-06
Stop SQL Injection Attacks Before They Stop You
Comments posted to this topic are about the content posted at http://msdn.microsoft.com/msdnmag/issues/04/09/SQLInjecti
2004-08-18
3 reads
2004-07-27
how to update records
i have recrods e.g :0523422 we like update to 05023422 that means add '0' after 05 to all records
2004-07-25
RE: Oracle Connection in DTS
You'll want the Oracle client tools on the SQL server, and then make sure (depending on the version of Oracle) that you have the correct entries in the registry (see http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B280106 . Then you'll have to set up the tnsnames entries for the connections. That's it.
2004-07-20
RE: Backup Possessive or Performance hog ???
Its most likely a permissions issue. The account that SQL is running under doesn't have rights to your mapped drive. If at all possible, backup your databases to a local drive and then move them to your network share.Steve
2004-06-30
RE: Anyway other faster way to do this?
Thanx rockmoose, I should have thought of this...sum first then crosstab. This works much better than my current solution.
2004-05-31
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers