Viewing 15 posts - 16 through 30 (of 57 total)
> What would be the ascii number for that character.
You have the data, so you can go look -- people here do not have the data, so they cannot say.
I'd...
March 6, 2006 at 4:30 pm
As an earlier commenter suggested, your problem is likely cardinality (of course we cannot know for sure, as we cannot see the data).
Look to see if contact->organization is 1:1 or...
March 6, 2006 at 4:28 pm
To tune it, I'd expect you'd want to tune it so that particular uses run quickly -- the uses that you expect to see, or that you actually see. But,...
March 6, 2006 at 12:19 pm
I cannot read the referenced JPG, but you could make an AddressType table, which could map your address type to an address type name, and then add the address types...
March 6, 2006 at 12:17 pm
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Neither lists a Developer Edition
I don't know if Express Edition (which is temporarily free) allows accessing other instances?
March 6, 2006 at 11:26 am
Any chance you forgot to call it with the OUTPUT specifier in the caller?
I mean
exec displaypkgerrors @pkg, @error
will appear to work, but the variable @error won't be returned
whereas
exec displaypkgerrors @pkg,...
March 5, 2006 at 11:29 pm
I might run Depends (Microsoft's Dependency Walker) on that dll, to see what other dlls it depends on, and more importantly, to see if any are missing.
March 5, 2006 at 11:26 pm
There are probably a variety of ways to address this.
One way would be to create a view joining together the fields you want to be searchable, so you can issue...
March 5, 2006 at 11:22 pm
Also, Jeff's solution as is requires there be exactly one space between each part.
This won't be safe if humans are typing these in, but then again, if humans are...
March 5, 2006 at 11:04 pm
I'm probably pointing out something you guys already realize, but the original poster seems to be making the assumption that there are no spaces in names or titles, and the...
March 5, 2006 at 11:02 pm
Look at the table syscolumns at the [status] column.
Or google -- eg:
March 5, 2006 at 10:59 pm
For script tasks, you need to list the variables you will use as either ReadOnly or ReadWrite on the general tab.
For calling sprocs with the builtin SSIS execute sql task,...
March 5, 2006 at 10:47 pm
I don't see the hole in the logic guys.
(Let me requote the trigger, as this board is not great for navigation)
Where is the problem with multiple rows?
INSERT INTO [dbo].[tbl_pts_positions_history]...
February 23, 2006 at 5:00 pm
Yes, I believe that I added a warning to my first message, that your test would not work the way you probably want, if ANSI_NULLs is in effect.
Glad you have...
February 21, 2006 at 12:10 pm
Also, I don't see any extra history records when I test it. Do you get the same results I post below? Can you post the details (including queries) of the...
February 21, 2006 at 11:56 am
Viewing 15 posts - 16 through 30 (of 57 total)