Viewing 15 posts - 3,166 through 3,180 (of 14,953 total)
In the Execute SQL Task, you put question marks in the query, and use the Parameters function to define them with the package variables.
- 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
October 10, 2011 at 7:55 am
Okay, let's see if I understand this correctly:
1. Insert data into a worktable
2. Import data from a spreadsheet
3. Calculate data from spreadsheet
4. Update worktable
5. Insert/Update data in primary table from...
- 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
October 10, 2011 at 6:44 am
I'm not clear on what you're asking.
Are you having trouble with the export? Are you trying to have it automatically export data when a value changes in a table?
- 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
October 10, 2011 at 6:39 am
Not in SQL 2000. At least not that I know.
- 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
October 10, 2011 at 6:21 am
The Trial Edition of SQL Server 2008 is free, works for 6 months, and is the same as Enterprise/Developer Edition in terms of features.
You can use that for evaluating 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
October 7, 2011 at 1:26 pm
Query the data vertically, returning months as rows, and have the presentation layer pivot it. Excel, SSRS, CrystalReports, et al, can pivot rows into columns efficiently and 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
October 7, 2011 at 1:03 pm
Object_ID can take the database and schema name as well as the object name.
select OBJECT_ID(N'MyDatabase.dbo.MyObject')
Does that help?
- 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
October 7, 2011 at 1:02 pm
You need to separate your OR from your ANDS with parentheses.
Select * from posted_job where (job_location='" + jb_location + "' and Dept='" + function_area + "' OR Skills like '%''"...
- 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
October 7, 2011 at 1:01 pm
Stefan Krzywicki (10/7/2011)
GSquared (10/7/2011)
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...
Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we...
- 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
October 7, 2011 at 12:00 pm
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...
Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA...
- 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
October 7, 2011 at 9:32 am
I'm busy prepping for another attempt at moving our servers to a new datacenter.
The last one, the SAN engineer forgot to mark the partition on a LUN as NTFS, and...
- 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
October 7, 2011 at 8:21 am
Storing the PIN on the card is definitely a bad idea. Would defeat the purpose of having a PIN in the first place, since the PIN would have to...
- 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
October 7, 2011 at 8:14 am
Ninja's_RGR'us (10/7/2011)
jay holovacs (10/7/2011)
We do an offfsite DR test 2x per year.In addition we are in a building with diesel generators and sufficient fuel to run for several weeks.
When you...
- 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
October 7, 2011 at 8:09 am
SQL 2000 doesn't have a built-in way to do that.
What you'll need to do is test for rows that are above the allowed size before you insert the data. ...
- 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
October 7, 2011 at 6:13 am
You're welcome.
- 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
October 7, 2011 at 6:06 am
Viewing 15 posts - 3,166 through 3,180 (of 14,953 total)