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.
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...
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?
October 10, 2011 at 6:39 am
Not in SQL 2000. At least not that I know.
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...
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.
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?
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 '%''"...
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...
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...
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...
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...
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...
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. ...
October 7, 2011 at 6:13 am
You're welcome.
October 7, 2011 at 6:06 am
Viewing 15 posts - 3,166 through 3,180 (of 14,953 total)