Viewing 15 posts - 2,626 through 2,640 (of 2,894 total)
mpdillon (6/30/2010)
When I update a Decimal(18,6) field type by dividing two Int field types, SQL does not do an implicit conversion.
...
I was astounded to find the the integer 2...
June 30, 2010 at 9:53 am
Brandie Tarvin (6/30/2010)
June 30, 2010 at 9:22 am
Actually, recursive CTE is not far from RBAR (can be even worse in performance)...
What you need can be achieved by a single update:
UPDATE Store SET FedTaxID = CAST(RAND(F.FranchiseID) * 1000000000...
June 30, 2010 at 8:52 am
This is about internal structure of SQL Server and its internal operations..
http://www.sqlmag.com/article/internals-and-architecture/sql-server-internals-viewer.aspx
June 30, 2010 at 8:34 am
diva.mayas (6/30/2010)
Thank you, its clear now why a table of a column can contain only one IDENTITY property.
Actually, it is down to MS SQLServer implementation of AUTO INCREMENTING.
You can find...
June 30, 2010 at 8:27 am
1. Using single numeric key (DocNo) will make join between your Master and Details table work faster!
2. Getting FormulaID when just retrieving details will be slower as it will require...
June 30, 2010 at 7:47 am
Jeff Moden (6/29/2010)
Actually, I have to admit, my really cool (or so I thought :blush: )method got the pants beat off it by simple nested replacements. Check out the...
June 30, 2010 at 5:28 am
Jason Messersmith (6/29/2010)
Eugene Elutin (6/29/2010)
Have you ever updated statistics on this table? 😀That's a good call, I'll give that a try and let you know.
Have you tried?
June 29, 2010 at 4:33 pm
scott.pletcher (6/29/2010)
Since you have multiple occurences within the string,...
June 29, 2010 at 2:53 pm
rahulsony111 (6/29/2010)
Thank you for the reply,the Sales_yr is a Year column it has values like 2009, 2010, 2011 etc,...
Cool! It explains everything!
So, you want an average value, isn't it?...
June 29, 2010 at 2:41 pm
Stefan_G (6/29/2010)
Keith Underwood (6/29/2010)
He was using the GUI, so all he did was put back in the name of the table "batch", not dbo.batch.
Well, there are two possibilities:
1) There is...
June 29, 2010 at 10:33 am
In this case, you can use FOR XML PATH (it takes much less space than FOR EXPLICIT "query from hell"), as you will only read Table_2 and Table_3 once for...
June 29, 2010 at 10:28 am
rahulsony111 (6/29/2010)
I have a table with columns proj_id char(5), tenant_id char(6), lease_id char(8), Sales_yr numeric(4)
i want to distinct only proj_id, tenant_Id, Lease_id but not sales_yr how can we do...
June 29, 2010 at 10:14 am
It depends on many factors...
Have a look this: http://msdn.microsoft.com/en-us/library/ms175515.aspx
June 29, 2010 at 10:10 am
try:
UPDATE Temp set Discounturl = replace(replace(replace(Discount,'--','-~'),'-~',''),'-',' ')
EDITED AS THE ABOVE HAS A BUG.
See my next post
June 29, 2010 at 10:04 am
Viewing 15 posts - 2,626 through 2,640 (of 2,894 total)