Viewing 15 posts - 1,591 through 1,605 (of 3,232 total)
Is that the only other place you'll be using the IDList? Maybe it would help if you could give a brief description of the package's purpose and the logic...
August 25, 2008 at 9:46 am
You'll still need to change the data type to 'object'. Try that out and let us know if you get past your error.
August 25, 2008 at 9:23 am
Any time you are storing a recordset (even if its a single row) into a package variable, you must define it as an 'object' data type, not string. Change...
August 22, 2008 at 2:57 pm
You're quick Barry. I checked for other responses just before clicking the Post Reply button.
August 14, 2008 at 4:35 pm
The GO statement is used by osql and isql to logically break a SQL script into batches that it can send to the SQL Server. Each chunk of code...
August 14, 2008 at 4:33 pm
I've got to roll out for the day, but I'm real curious as to what some of the other heavy hitters are going to say.
You mentioned thinking bigger....
August 13, 2008 at 4:11 pm
Thats better. Thanks Sam. So what you really want to display is any student who has had an F in any class?
I'm taking off for the...
August 13, 2008 at 4:07 pm
OK, then you have to rely on the setup table maintaining your data integrity? Why add another layer? If you were going to go this route, why not...
August 13, 2008 at 3:52 pm
You should not need a cursor to run a delete. What's wrong with a simple SP that does the following?
BEGIN TRANSACTION
DELETE c1
FROM Child1 c1
...
August 13, 2008 at 3:35 pm
First off, keep in mind that NOLOCK is equivelant to READ UNCOMMITTED isolation so you are reading dirty data. There's a bunch of problems that can come from this....
August 13, 2008 at 3:26 pm
This should help: http://www.sqlservercentral.com/articles/Test+Data/61572/
August 13, 2008 at 3:13 pm
So do you have a question? A problem?
August 13, 2008 at 3:09 pm
You need a BEGIN/END around the statements between your IF and ELSE.
August 13, 2008 at 3:08 pm
Actually, it depends on what you are doing. If you are using SUM(), NULLs will be handled for you. Here's a great link for you to read:
http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/
August 13, 2008 at 2:38 pm
Viewing 15 posts - 1,591 through 1,605 (of 3,232 total)