Viewing 15 posts - 2,896 through 2,910 (of 14,953 total)
Restricted Session and Single-User aren't the same thing. Single-User just blocks anyone else from using the database at the same time. Doesn't restrict the number of transactions, et...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 9, 2011 at 6:43 am
L' Eomot Inversé (11/9/2011)
Koen Verbeeck (11/8/2011)
L' Eomot Inversé (11/8/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 9, 2011 at 6:35 am
GilaMonster (11/8/2011)
How can BCNF be sensibly discussed if the earlier normal forms aren't known?
Same way you can teach Algebra without learning Arithmetic first. You just ... uh ... well...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 9, 2011 at 6:24 am
Steve Jones - SSC Editor (11/8/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 9, 2011 at 6:22 am
It's iterating through weeks. 7 doesn't indicate June (not sure why it would, but it's commented that way), it's a multiple of a number of days based on the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 9, 2011 at 6:18 am
L' Eomot Inversé (11/8/2011)
Roy Ernest (11/8/2011)
I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal)...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 2:26 pm
jshahan (11/8/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 2:20 pm
Finding overlap is easy.
If the AvailableTo is later than the AppointmentStart, and the AvailableFrom is earlier than the AppointmentEnd, then they have an overlap. That's a simple join condition.
What...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 2:08 pm
SQL Kiwi (11/8/2011)
PaulB-TheOneAndOnly (11/8/2011)
Not in the sense of over-booking partial flight legs like this system does
Fair enough. Booking part of a flight is an intriguing idea though - parachutes...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 1:59 pm
If you can use them, Table Valued Parameters (TVPs) are a new feature in SQL 2008 which do this very, very well. It's basically what Dixie Flatline suggested, but...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 1:33 pm
I usually go to properties of the connection, click on the "..." button next to Expressions, select Connection String from the drop-down, build the expression.
I'm assuming you've tried that already,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 1:30 pm
I checked, and the connection string for xlsm files needs to be "Excel 12.0 Macro". Try that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 12:50 pm
Have you made sure you have that connection driver installed?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 12:48 pm
Try this format for the connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SSIS\TXQuoteActivity\TXQuoteActivity.xlsm;Extended Properties="Excel 12.0 Xml;HDR=YES";
(You have the file extension as "xlsm". I'm used to "xlsx". Is that a typo, or is the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 12:44 pm
Is the connection string blank/incomplete at validation-time, and populated by a variable at runtime?
If so, have you set Delayed Validation on the package?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 8, 2011 at 11:37 am
Viewing 15 posts - 2,896 through 2,910 (of 14,953 total)