Viewing 15 posts - 3,556 through 3,570 (of 4,087 total)
You have to be careful with the joins, if either of the tables has a one-to-many relationship. You could potentially be double-counting some of the records I would use...
October 12, 2011 at 8:41 am
memostone86 (10/11/2011)
Thank you so much Toddasd, it works great
Actually, it doesn't work correctly. It assumes that there is only one change in the power status for each VM in...
October 11, 2011 at 2:52 pm
The most likely reason is that your interim result set has a column that is not being pivoted on nor in the final select list. PIVOT groups by ALL...
October 11, 2011 at 2:43 pm
Your approach is fraught with problems. For example, what if the load fails on a Friday and you're trying to load it on a Monday? Yesterday's filename will...
October 11, 2011 at 12:11 pm
bkubicek (10/11/2011)
You seem to be joining to the same table over and...
October 11, 2011 at 8:35 am
By default, an Execute SQL Task only returns success/failure information to the package. If you want to use the output of a result set, you need to specify the...
October 10, 2011 at 3:12 pm
Your PARTITION BY is wrong. You want the last record for each Service_Tag, so the PARTITION BY should just be on the Service_Tag, and not on the Service_Tag, Employee_ID...
October 7, 2011 at 1:38 pm
This is just a guess, but it probably needs consistent resultsets. That would mean no IF statements, no dynamic SQL, etc. In this particular example, you can replace...
October 7, 2011 at 11:06 am
Performace Guard (Shehap) (10/7/2011)
October 7, 2011 at 10:16 am
Now that you mention it, my trigger actually did the reverse. The person who designed one of the tables didn't normalize it properly. The trigger I wrote created...
October 7, 2011 at 10:02 am
I'm not sure that this is a T-SQL issue. You may have better luck posting in a forum for the application/language that you are working with. I did...
October 7, 2011 at 9:33 am
GilaMonster (10/6/2011)
Read up on the UPDATED() and COLUMNS_UPDATED () functions.
When doing UPDATEs, you should be aware that UPDATED() does not necessarily mean CHANGED. It simply means that a...
October 7, 2011 at 8:43 am
I don't think so, because of the following condition "clsdt_date = wrkcpl_date".
You can't do an index seek on cssdt_date until you know the values for wrkcpl_date. You can't do...
October 6, 2011 at 3:05 pm
You're mixing the syntax for UPDATE and UPDATETEXT. You need to use one or the other.
text fields are being deprecated. You should consider changing it to a varchar(max)...
October 6, 2011 at 2:24 pm
kramaswamy (10/6/2011)
That one unfortunately gives me a result of 92 minutes, while the actual result should be 62 minutes.
I'm getting 62 minutes. Which set of data are you using?
Drew
October 6, 2011 at 1:26 pm
Viewing 15 posts - 3,556 through 3,570 (of 4,087 total)