Viewing 15 posts - 1,156 through 1,170 (of 1,347 total)
There is still insufficient info to anser this. Franks question: "How will this happen?" is important.
Is this 1 connection to the DB performing the inserts, or is it several, 10,...
February 22, 2005 at 9:27 am
Interesting, in the code that was linked to on SqlJunkies.com, there is actually a bug in the temp table method:
SELECT State, au_lname, IDENTITY(INT, 1, 1) AS Ident
INTO #AuthorConcat
FROM Authors
ORDER BY...
February 22, 2005 at 9:22 am
Is column oid indexed in database 1 ? If so, it might run better as an EXISTS subquery:
DELETE FROM database2.dbo.transactions del
WHERE EXISTS
(SELECT * FROM database1.dbo.transactions TR WHERE del.oid = TR.oid)
Also,...
February 21, 2005 at 7:39 pm
Use the CAST() or CONVERT() functions to perform data type conversions.
February 21, 2005 at 3:15 pm
What are your business rules for deciding a tie-break if 2 industry codes emerge with the same min(empl) ? The solution depends on those rules.
February 21, 2005 at 11:24 am
>>I do have exclude public holidays as well but I just wanted to deal with the weekends part of it first.
Unfortunately this is a case where looking at a small...
February 20, 2005 at 4:31 pm
Define "Business days". Is it always just non-weekends ? What about public holidays ? Other custom definitions for your business ?
February 19, 2005 at 6:35 pm
Nope, you're taking aggregates of 3 different columns - and the Group By in the virtual table is incorrect, because you're grouping on the things you're aggregating.
This method works by...
February 18, 2005 at 3:10 pm
February 18, 2005 at 2:44 pm
February 18, 2005 at 2:18 pm
Once you've decided on a definition of "first", see this thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=162585
February 18, 2005 at 1:43 pm
>>INSERT the first occurance of the duplicated record
Solution to this always starts with a requirements question - how is "First" defined for your business ?
SQL row data is unordered...
February 18, 2005 at 1:37 pm
Could be as simple as:
StudentID, ClassID, Date
You don't really need Month/Year, they are easily derived from the actual date. Existence of a record in this table indicates attendance on that...
February 18, 2005 at 12:54 pm
Well, your call, but ignoring established normalization rules, and modelling the data according to how it is displayed in a certain presentation layer will nearly always bite you later.
What if...
February 18, 2005 at 12:12 pm
As advised above, please read BOL, it's all there. From the BOL section titled "Bit":
Integer data type 1, 0, or NULL.
Columns of type bit cannot have indexes on them....
February 18, 2005 at 11:06 am
Viewing 15 posts - 1,156 through 1,170 (of 1,347 total)