Viewing 15 posts - 1,501 through 1,515 (of 3,232 total)
Timothy is correct. Furthermore, variables of type object must be mapped to a collection or recordset. You would typically do this inside the packge by an ExecuteSQL task.
January 16, 2009 at 11:22 am
How 'bout you take a stab at it first, then post your code so we can help you? BTW, please include example data and your expected results.
January 16, 2009 at 11:18 am
Joe, to be honest, it will be difficult for anyone to help you based off of what you posted. We don't have any of those tables, or any data...
January 16, 2009 at 10:32 am
gyessql is absolutly correct. Thanks for catching my mistake. You cannot reference a table outside of the SQL statement. gyessql's solution will work, and so would something...
January 16, 2009 at 10:24 am
Gail and Colin have you going down the right path. I'd continue to focus on the I/Os at the SAN level. You say that your DB instance has...
January 15, 2009 at 3:50 pm
I would recommend following Robert's advice. Here's some code to work with. You'll have to add to the select list to get all of your columns, but this...
January 15, 2009 at 2:36 pm
I see a few things here that would concern me. First off, it looks like you are using a sequence table to manage your PKs, correct? This is...
January 15, 2009 at 2:18 pm
Robert klimes (1/15/2009)
bocleared cleareddate ctcleared cleareddate totalcleared cleareddate
2 1/2/2009 ...
January 15, 2009 at 1:26 pm
You're IF EXISTS...SELECT statement is missing the alias name for the table.
Try this:
if (EXISTS(select name from tablename table2 where name = table2.name and date = table2.date))
begin
Or this:
if (EXISTS(select...
January 14, 2009 at 10:26 pm
Times of economic downturns represent great times for opportunty for those who are looking for it. While the masses are busy pulling all of thier limbs into their shells,...
January 14, 2009 at 3:32 pm
It may just be your Express version of Management Studios. We had a developer here who was having problems seeing the service broker and it was because he had...
January 14, 2009 at 11:43 am
Great. Thanks for the feedback.
January 12, 2009 at 9:20 am
That should definately work, but just in case, here's a couple more alternatives:
1. Shut down the service from another computer, then copy files.
OR
2. Most laptops allow you to redirect the...
January 9, 2009 at 3:40 pm
Yep. Many of the interworkings of SQL Server are cursors under the hood. This just beats writing one and works fine for admin tasks.
January 9, 2009 at 1:46 pm
I was missing something! I did not notice that you had both the column name and *.
Thanks.
January 9, 2009 at 10:50 am
Viewing 15 posts - 1,501 through 1,515 (of 3,232 total)