Viewing 15 posts - 241 through 255 (of 514 total)
oops unnecessary table.
SELECT course.cname,ENROLL.classno
FROM course
INNER JOIN ENROLL
ON COURSE.cno = ENROLL.cno
...
October 31, 2007 at 6:39 am
Ok... Since you tried 4 we will continue with it.
SELECT course.cname,class.classno
FROM course
INNER JOIN class
ON COURSE.cno = CLASS.cno
...
October 31, 2007 at 6:35 am
Not sure you are going to be able to tell. The files that are created are sparse files, so they appear to be the same size as the actual...
October 30, 2007 at 7:32 am
Oh by the way... Proper structure for that table should be 1 table, not 2.
CREATE TABLE BOM_Construct (
ID INT IDENTITY PRIMARY KEY,
PART_OF INT NULL FOREIGN KEY...
October 30, 2007 at 7:25 am
Pivot will only work if you know the column names.
Dynamic SQL is about your only option here.
CASE statements or Pivot would be the way to implement...
October 30, 2007 at 7:21 am
As Brandie stated:
The Snapshot is read-only. When you say that you need to understand how the "Insert" works but not the "update", it appears you don't understand how either...
October 30, 2007 at 6:52 am
Sergiy (10/29/2007)
This just shows how poor and limited is your T-SQL knowledge.
Another confirmation to my point about bad design.
Completely unnecessary comment. There are much more constructive ways to explain...
October 30, 2007 at 5:27 am
Jo Pattyn (10/13/2007)
http://www.7-zip.org/%5B/quote%5D
I'll give my stamp of approval on 7-zip. I have used it for years now. Not only does it...
October 29, 2007 at 11:15 am
I am going to start off with the summary. Management/Business requirements should determine what is the proper avenue to persue. Sometimes readability/supportablity is more important to the business...
October 29, 2007 at 11:06 am
Peter Gadsby (10/29/2007)
It has been slowly increasing in time, although recently it increased from running in 10 hours to 13 hours (a year ago it was running in 6 hours).
6-13...
October 29, 2007 at 9:55 am
I have heard the phrase "nothing has changed, but it just got slow all at once" many many times. I have always found something that has changed in these...
October 29, 2007 at 8:41 am
I read through this, but forgive me if I missed someone else mentioning either of these.
I have heard nothing about the performance of the ETL server, just the...
October 29, 2007 at 6:30 am
Antares686 (10/26/2007)
October 26, 2007 at 1:15 pm
If you have the need (and most do) for a DR system, setup log shipping. Although this isn't a direct test of the backups, it is an indirect test,...
October 26, 2007 at 10:48 am
End Users should not have access to direct SQL. PERIOD! If it is a reporting system some visual tool yes, but not SSMS.
Developers should have read only rights...
October 26, 2007 at 10:34 am
Viewing 15 posts - 241 through 255 (of 514 total)