Viewing 5 posts - 1 through 5 (of 5 total)
There is error in answer.
"What is the maximum relational database size of the SQL Server 2014 edition can grow to?"
https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
Maximum relational Database size = 524 PB
There isn't word...
July 24, 2015 at 1:52 am
Mikael Eriksson SE (10/17/2013)
It is the same in SQL Server 2005, 2008 and 2012.If you want to check what the compiled value is you can use this.
...
Thanks. Very interesting!
October 17, 2013 at 2:00 am
It doesn't work correctly
martinez.math (11/16/2012)
Example 2DOB = 11/14/1987 and
datenow =11/15/2012 the result would be
AGE=24
should be AGE=25
but your code returns 24 (:
p.s. It computes my age incorrect 🙁
November 16, 2012 at 6:46 am
You could think about something like this:
SELECT Comp.*
FROM #Companies AS Comp
LEFT JOIN #CompanyGroups AS Gr ON Comp.CompanyID = Gr.CompanyID
WHERE Comp.CompanyID = @CompanyID
OR GR.CompanyGroupID = @CompanyGroupID
November 15, 2012 at 11:36 pm
Additional questions. What results should be for this?
CREATE TABLE #Companies (CompanyID int)
INSERT INTO #Companies (CompanyID) VALUES (1)
INSERT INTO #Companies (CompanyID) VALUES (2)
INSERT INTO #Companies (CompanyID) VALUES (3)
CREATE TABLE #CompanyGroups (CompanyGroupID...
November 15, 2012 at 11:35 pm
Viewing 5 posts - 1 through 5 (of 5 total)