Viewing 15 posts - 481 through 495 (of 1,131 total)
SQL Code for condition 5 got messed up and the Greater than and Less Than signs are making the code disappear - just replace GT and LT with the approriate...
SQL = Scarcely Qualifies as a Language
May 13, 2008 at 2:57 pm
There are 5 overlap conditions between a Club interval and and Address interval which means that they occur during the same interval. This is easiest shown graphically with...
SQL = Scarcely Qualifies as a Language
May 13, 2008 at 2:41 pm
Why would you need to know the original SQL Statement ?
Note also that only someone with sysadmin rights can run
DBCC INPUTBUFFER and most sites will not allow...
SQL = Scarcely Qualifies as a Language
May 13, 2008 at 10:37 am
Error 3624 indicates that there is data corruption. Please check the ERRORLOG for any messages.
SQL = Scarcely Qualifies as a Language
May 12, 2008 at 5:41 pm
For such simple SQL, as the execution plan will be very short, this is the simpliest method - using SQL Server Management Studio, open a query window and paste in...
SQL = Scarcely Qualifies as a Language
May 12, 2008 at 5:26 pm
One more disadvantage of a single database with multiple schemas - The customer calls and indicates that they have messed up the data and want there information restored from backup...
SQL = Scarcely Qualifies as a Language
May 12, 2008 at 8:43 am
Just saw on bottom of the forum post for subscription option this literal "Note: Your selection is saved as a default for next time ". Will let you know...
SQL = Scarcely Qualifies as a Language
May 12, 2008 at 8:16 am
"in the profiler in the reads column for the audit logout class event de number is very high. "
For the logout event, the values for CPU, Reads and Writes are...
SQL = Scarcely Qualifies as a Language
May 12, 2008 at 8:14 am
The change made are listed below and recommend replacing hard-coded database names with synomyms to have location independent of the name.
Changes:
For clarity, the table alias that are one character have...
SQL = Scarcely Qualifies as a Language
May 11, 2008 at 6:00 am
Indexes definitions are not compatible between Oracle and SQL Server and must be extensively modified.
Packages are not supported by SQL Server.
Trigger are not compatible between Oracle and SQL Server and...
SQL = Scarcely Qualifies as a Language
May 11, 2008 at 4:29 am
Regarding your questions:
Q: Is it viable to have an architecture with separate schemas for tables but with single stored procedures that will dynamically work with the sperate schemas?
A:...
SQL = Scarcely Qualifies as a Language
May 11, 2008 at 4:22 am
"Boycott SQL Server 2008" ?
I have boycotted SQL Server 2005! - the number of fixes per week is astounding !
SQL = Scarcely Qualifies as a Language
May 10, 2008 at 4:33 pm
Noticed that you did state "Combination of Department and Team_ID generate a primary key.", a normalized schema is below. Notice the on update cascade for DepartmentName.
You could add a DepartmentId...
SQL = Scarcely Qualifies as a Language
May 10, 2008 at 9:56 am
Tried Jeff Moden's suggestion to use "context switching" but I cannot get this to work based on three schemas and a dbo schema stored procedure, where the schema of the...
SQL = Scarcely Qualifies as a Language
May 10, 2008 at 9:28 am
The name for what you are attempting to do is a PIVOT. Please be sure to check the value of the constants as a typo is probable.
SELECTv_R_System.Name0
,MAX ( CASE...
SQL = Scarcely Qualifies as a Language
May 9, 2008 at 9:40 pm
Viewing 15 posts - 481 through 495 (of 1,131 total)