Viewing 15 posts - 691 through 705 (of 1,347 total)
Get rid of the variable and use a true set-based update:
IF UPDATE(LastMove)
BEGIN
UPDATE u
SET status = 1
FROM Intranet.dbo._Users AS u
INNER JOIN INSERTED AS i
ON (u.personNo = i.Person)...
January 18, 2006 at 2:58 pm
What if you UPDATE more than 1 row at once ?
>>SELECT @noPerson = Person FROM INSERTED
What are you expecting to be in @noPerson if there are multiple records in the...
January 18, 2006 at 2:48 pm
There have been some good articles on this issue (though in SSIS, not DTS) in Jamie Thompson's blog. "Keeping your packages in the dark". However, the concept is equally applicable...
January 18, 2006 at 2:21 pm
Select Date, t.Employer
From #t As t
Inner Join
(
Select Employer, Min(Date) As SortValue
From #t
Group by Employer
) dtSorted
On ( t.Employer = dtSorted.Employer )
Order By dtSorted.SortValue, t.Employer, t.Date
[Edit] Fixed...
January 18, 2006 at 1:21 pm
See response by MS Online Support - Sameer is correct, it is due to McAfee.
January 18, 2006 at 1:13 pm
This is what you posted:
>>Here is an example of how I want the result set to be ordered:
>>Date Employer
>>1968 Bill's Tires
>>1971 Bill's Tires
>>1968 Dell Computer
You clearly show date sorted within...
January 18, 2006 at 1:06 pm
>>and just leave the first one. How can I do it?
You start with the business requirements and a definition of "first one".
Oldest ? Newest ? Most complete address ? Highest...
January 18, 2006 at 9:58 am
I get the same incorrect result on SP4. I see it referred to as a known bug in the SQL Server newsgroups at Microsoft:
January 18, 2006 at 9:22 am
A similar issue affects Reporting Services. The workaround there (not sure if it applies to SSIS) is to use this as the SQL statement:
SET FMTONLY OFF EXEC YourProcName
(Typically...
January 18, 2006 at 7:59 am
I get the same incorrect result on SP4. I see it referred to as a known bug in the SQL Server newsgroups at Microsoft:
January 18, 2006 at 7:20 am
>>If you will see the view create script it's not using "SELECT *".
Yep, saw that. Just some people post `generalised` code to prevent posting confidential information to the forums, so...
January 17, 2006 at 10:44 pm
Are these real views ? Or are you using sample code to illustrate the general concept ?
On your systems, do any of your views contain SELECT * <- emphasis on the...
January 17, 2006 at 10:28 pm
What exactly are you trying to do ?
I just tested this in an ActiveX script task and it works fine:
Function Main()
If Not ("Apples" = "Oranges")...
January 17, 2006 at 10:23 pm
>>How come it works with an alias as oppossed to the actual table name?
It's how the SQL parser correlates what's being UPDATEd with what's in the FROM.
If you alias a...
January 17, 2006 at 10:06 pm
I guess the power of lookups comes from the ability to run each on a different data source, so you can implement some very complex cross-server processes.
The price of all...
January 17, 2006 at 5:02 pm
Viewing 15 posts - 691 through 705 (of 1,347 total)